ARTICLE AD BOX
I have an Excel file of 13 MB which, when loaded using XSSFWorkbook, consumes around 1.5 GB of heap memory, which is too much for my use case.
How can I reduce heap memory usage?
I tried other Apache POI objects: SXSSFWorkbook is memory-efficient for writing, but since it keeps only a limited number of rows in memory, it cannot evaluate formulas.
I could not find any library that is both memory efficient and able to evaluate Excel formulas.
What alternative do I have?
