How's the memory consumption of using aspose.cells? especially comparing to Apache POI? e.g. how much memory would be required to generate a 1m rows, 100 columns worksheet with styling, comments, cell mergeing etc.?
This message was posted using Aspose.Live 2 Forum
Hi,
I am afraid, we don’t have specific test results for comparing Aspose.Cells with POI regarding memory consumptions. You can evaluate if by yourself conducting the tests. We do have a document for features comparison though, see the document: Aspose.Total for Java|Documentation
But one thing is certain if you are going to create a worksheet with Im rows and 100 columns (with styles, comments etc.), it would consume lot of memory and will take some time to process the task.
Generally, if a file has 10mb in size, it would consume 10 * 10(times) = 100mb or more memory to complete the process.
Thank you.