This is a file format port. The file format does not have the blank line. It is merely the absence of a row. This is the difference between a GRID model/spreadsheet engine and an API that represents the file format. A lot of folks think HSSF is a spreadsheet engine or port of Excel or whatever. It is a port of the file format only.
-andy
marc wrote:
Ok that was also me solution.
But do anybody now why it is only the first time around it do not take the blank line?
Marc
Alex Karshakevich wrote:
The rowIterator iterates only over actual rows. If a row is empty it may not be represented in the excel file. The iterator skips these nonexistent rows, so you may not get the same count as the row count of the sheet.
To iterate over _all_rows, null or not, I use HSSFSheet.getRow() and deal with nulls myself.
Alex.
--------------------------------------------------------------------- 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/
