I have a memory issue using Apache POI. When creating a workbook (org.apache.poi.ss.usermod
k) like so:
Workbook workbook = WorkbookFactory.create( inputStream );
It takes much memory. For example, executing that line on an excel file that is 73mb causes memory usage to jump by about 1gb (according to the Windows Task Manager - PF Usage)
1. Why so much memory?
2. Is there a way to read an create/read row-by-row or column-by-column?