Hi, I have a system where POI was used to generated an XLSX file with approximately 256 columns x 35,000 rows of data. We used SXSSFWorkbook to create it in order to maintain a reasonably small memory footprint. The resulting workbook is 24-28MB depending on whether shared strings are used.
Sometime later, we want to add an additional sheet to the workbook and we, again, want to create an SXSSFWorkbook to do the work. Unfortunately, the only mechanism available seems to be to create a an XSSFWorkbook first and then pass that into the constructor of the SXSSFWorkbook. The problem is that instantiating the XSSFWorkbook is exhausting a 4GB heap if I bump the heap up to 8GB (in this case), I can get it seems somewhat antithetical to the streaming approach in the first place. Is there any way to create an SXSSFWorkbook for an existing file without consuming all of that memory? Thanks
