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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
