On Wed, 7 Jul 2010, William Graham wrote:
In using either the getText or processSheet methods it seems that this
extractor somehow treats an empty cell as not actually being there when
it returns the delimited text.
That's because in the file format, empty cells really aren't there!
(.xlsx is a zip file of XML files, so you can unzip it and see for
yourself. Empty cells are skipped.) When using the usermodel, we can
detect this and return an empty cell for you if requested. If you're using
the event model, you're much too low down and it's all up to you...
For HSSF, we have a wrapper around the HSSF event based stuff that
watches the cell numbers, and spots when things are missed:
http://poi.apache.org/apidocs/org/apache/poi/hssf/eventusermodel/MissingRecordAwareHSSFListener.html
If this matters to you, I'd suggest you try writing similar logic for
XSSF. If you do get it working, do please send in the patch! :)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
