On Thu, 26 Aug 2010, Brian Trezise wrote:
No formulas, hidden cells, or anything fancy. Anywhere between 5 and 40
columns, and sometimes our datasets approach the 1,000,000 row limit of
.xlsx. I have been searching for a way to read and iterate over the
rows of these very large data files on and off for a month now with no
luck.
You want SAX parsing of the file, that's the quickest and lowest memory
way to do it. (Requires more work on your part though). See
http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
