How to parse xls file containing multiple sheets, within 50MB of memory, in Java

Question

I have used POI and Jexcel. POI uses as much memory as the file size and Jexcel take a lot of memory while loading a workbook. My requirement is to process an xls file in chunks, so as to reduce the memory consumption.

Answer 1

Apache POI provides a SAX like API to access Excel documents.

See Apache POI Event API:

The event API is newer than the User API. [...] The advantage provided is that you can read an XLS with a relatively small memory footprint.