Greetings, fellow POI users. I just wanted to check that my understanding is correct:
I have discovered that reading my entire workbook into memory using the obvious method of loading it as an XSSFWorkbook consumes many gigabytes of memory. I want to reduce this. Fortunately, my code is already set up to consume the rows in one pass, one at a time, so the obvious solution seems to be streaming. The classes in org.apache.poi.xssf.streaming.* (in particular, SXSSFWorkbook) are for streaming *write*. If I want to do streaming *read*, I need to follow the example of XSSFSheetXMLHandler, building something on top of SAX - i.e. there is no API as such for streaming read access to Row and Cell objects. Correct? Thanks, David -- David North, Technical Lead, CoreFiling Limited http://www.corefiling.com Phone: +44-1865-203192 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
