How do you know the cell is blank? Because you're going by the
row/column number you think you're looking at? Remember that the
row/column numbers are 0-based, not 1-based. Because of issues like
this, I like to have a dumpCellData method that goes through every row
and column, printing out the row/column numbers, the cell type, and the
string value of the cell.
-Original Message-
From: Hugo Osorio [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 12:48 PM
To: POI Users List
Subject: Re: empty cells with iterators
thank you, i have used this field, but, the cell seems not to
be blank, but it still appears to have data despite it is empty...
2007/4/3, Karr, David [EMAIL PROTECTED]:
Perhaps you're looking to check whether the cell type is blank.
Once you have a HSSFCell object, call getCellType() and
compare it
against HSSFCell.CELL_TYPE_BLANK.
-Original Message-
From: Hugo Osorio [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 8:50 AM
To: poi-user@jakarta.apache.org
Subject: empty cells with iterators
Hello,
How can i ask in the statement while(cellsIterator.hasNext()) AND
(some cell is not empty) since this cell is my control for
registering
thank you
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/