poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54327] New: cellIterator skips blank/unformatted cells in a row
Date Wed, 19 Dec 2012 11:37:51 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54327

            Bug ID: 54327
           Summary: cellIterator skips blank/unformatted cells in a row
           Product: POI
           Version: 3.5-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: mandicha.smitha@gmail.com
    Classification: Unclassified

Created attachment 29778
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29778&action=edit
sample excel

Summary: I need to process excel sheets by finding a header (i.e the first row
with 8 consecutive columns). The subsequent rows' following the header becomes
the data for the header cell values. 

Problem Statement: In a row if 2nd cell is blank and unformatted but the rest
of the cells in that row are formatted, then the 2nd cell is not read and hence
the values are messed up. 

Example: In the attached excel sheet, cell B4 and B6 are skipped by the
cellIterator and thus the header 'Completion Date' has the values of the next
columns i.e., M India Limited & Steel in row 4 and 6 respectively. But the same
is not true for 5th row. It is read properly though B5 is blank.

Please let me know the solution at the earliest. Also, the possible way to
un-format the entire excel sheet before processing.

-- 
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