On Mon, 22 Feb 2016, Lynn Li wrote:
When using SAXParser to parse xlsx file, blank cells are skipped.
Does anyone have code to not skip blank cells using SAXParser? Any help
you can provide is appreciated.
You just need to keep track of the cell reference of the last cell seen,
and spot gaps from that. It's fairly easy to do, a good example is in the
XLSX to CSV example that uses the SAX parsing stuff to do it:
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]