On Mon, 5 Sep 2011, Simmons, Tom (GE Oil & Gas, VG) wrote:
Obviously this is working by loading the file into memory and some of
the files I received are 50, 80 + MB in size.
Nope, when you pass an InputStream to POIFSFileSystem or NPOIFSFileSystem,
only the first few bytes are checked for the magic marker. If the file is
really an OOXML file, it'll fail fast
Also, if you have files on disk, then you probably don't want to wrap them
in InputStreams. Both NPOIFSFileSystem and OPCPackage have constructors
that work directly with files
Also, is there a similar idea of sliding window available for the older
XLS files so as to reduce the memory footprint?
Only for reading, you'd probably want:
http://poi.apache.org/spreadsheet/how-to.html#record_aware_event_api
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
