On Wed, 23 Mar 2016, arashmoeenj wrote:
In my project I have to parse a xlsm file which contains more than 1
million rows (separated in multiple sheets each containing 1 million
rows at maximum), and do some validations on the cells.
I've tried so many examples provided by Apache POI and StackOverFlow but
still couldn't manage to find a proper way to parse starting the first
row/cell to the last one.
For a file that big, you likely want to be doing either low-level SAX
parsing, or more likely use the mid-level SAX-based SheetContentsHandler
interface
P.S: I need the blank cells to be also included in the parsing section.
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
shows how to handle missing cells and missing rows when using the
mid-level SheetContentsHandler with the SAX stuff
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
