I have a section of code which reads in a spreadsheet in the standard HSSF
manner as described on the project web pages. The cellIterator in use
causes me problems whenever I encounter blank cells at the beginning of a
row. As the iterator searches for physical cells, these blank ones get
ignored and so the structure of the spreadsheet is affected (in this case,
the blank cells serve to space a row of "column total" formula cells
correctly). Is there a way of forcing the cellIterator to include blank
cells? Or would I do better to stipulate a fixed number of columns and use
a for loop?
On a similar note, the cellIterator returns the cells in descending order
for some reason, essentially reading them along the row from right to left.
Is this normal? In order to create the correct dataset to later create a
table object, I am forced to use insertElementAt(value, index 0) which works
well enough but I do not feel this is very satisfactory. This also
contributes to the above problem in some way, as reading from right to left
any leading blank cells can be safely ignored.
Any help will be appreciated. Thanks.
David
"I like work: it fascinates me. I could sit and look at it for hours."
- Jerome K Jerome
"Three Men in a Boat"
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
