Thanks Nick. Looks like that'll read the stuff (if a bit awkwardly... not seeing an easy way to convert the example into an iterator for external processing of one row at a time). However, that aside, I'm now being asked if it is possible to write files with the event model. My understanding from looking at this is that it won't go both ways, but please correct me if I'm wrong? (Preferably with some kind of example)
Thanks, ----------------------------- Brian Trezise IntelliData, Inc. Staff Software Engineer [email protected] t: 720.524.4864 m: 303.809.9782 -----Original Message----- From: Nick Burch [mailto:[email protected]] Sent: Thursday, August 26, 2010 14:00 To: POI Users List Subject: Re: I need to read only (not write) large xls and xlsx files 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
