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]

Reply via email to