poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lynn Li <lynn...@gm.com>
Subject When using SAXParser to parse xlsx file, blank cells are skipped
Date Mon, 22 Feb 2016 22:48:10 GMT
When using SAXParser to parse xlsx file, blank cells are skipped.

https://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api has a note regarding this as follow:
One important thing to note with the basic Event API is that it triggers events only for things
actually stored within the file. With the XLSX file format, it is quite common for things
that have yet to be edited to simply not exist in the file. This means there may well be apparent
"gaps" in the record stream, which you need to work around.

Does anyone have code to not skip blank cells using SAXParser? Any help you can provide is
appreciated.

Lynn



Nothing in this message is intended to constitute an electronic signature unless a specific
statement to the contrary is included in this message.

Confidentiality Note: This message is intended only for the person or entity to which it is
addressed. It may contain confidential and/or privileged material. Any review, transmission,
dissemination or other use, or taking of any action in reliance upon this message by persons
or entities other than the intended recipient is prohibited and may be unlawful. If you received
this message in error, please contact the sender and delete it from your computer.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message