On Wed, 30 Apr 2008, Tom Holmes Jr. wrote:
However, this only gets back cells with data in them ... so I don't know why there is even a CELL_TYPE_BLANK.
If you put some data into a cell, then delete it again, excel will normally still store the cell in the file, but with type blank. If you have never put anything in the cell, then it won't appear in the file
With OOXML, excel is better at removing cells with no contents from the file, but you do still sometimes get cells of type blank.
The API docs don't offer much information on this. I presumed that getting the cell iterator would internally handle these null cells and they would register as CELL_TYPE_BLANK.
There aren't "null cells" in the file. For example, there will be a record for the cell in row 0 column 0, then the next record is for row 0 column 3. There is nothing in the file for row 0 columns 1 and 2. So, there's nothing for the iterator to return. If you ask the row for column 1, it'll give you back a null, as there's nothing there in the file
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
