Apache has a SXSSFWorkbook class that starts writing to a file after exceeding 100 lines during creation and consumes less memory. I have a question about how the aspose workbook works. thanks for the shelf.
I do not know much about Apache’s SXSSFWorkbook class and its working, so cannot compare it with Aspose.Cells.Workbook. Aspose.Cells, generally builds a complete data model block into memory. Please see the Aspose.Cells docs for your reference. However, it also has light -weight mode. Aspose.Cells provides the LightCells API, mainly designed to manipulate cell data one by one without building a complete data model block (using the Cell collection etc.) into memory. It works in an event-driven mode.
Hope, this helps you.
Thank you Amjad Sahi