poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 52220] New: unable to read blank cells from excel.
Date Mon, 21 Nov 2011 07:34:49 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=52220

             Bug #: 52220
           Summary: unable to read blank cells from excel.
           Product: POI
           Version: 3.7
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: chaitalimali20@gmail.com
    Classification: Unclassified


does not read blank cells from excel file 
{
XSSFWorkbook workbook = new XSSFWorkbook(fis)

XSSFSheet sheet = workbook.getSheetAt(0);


            Iterator rows = sheet.rowIterator();
            while (rows.hasNext()) {
            XSSFRow row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();

            List data = new ArrayList();
            while (cells.hasNext()) {


            XSSFCell cell = (XSSFCell) cells.next();


            data.add(cell);



            }
            //System.out.print(rowCount);

            sheetData.add(data);
            }
            }
        catch (IOException e) {
            e.printStackTrace();
            } 
        {
            if (fis != null) {
            fis.close();
            }
            }

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message