Thank you for considering Aspose.
What is the limiting factor in workbook size with Aspose?
Well, there is no such limitation of Workbook Size by Aspose. The only limitation would be the memory available.
Does the entire document have to be loaded into memory to save, as with POI, or is there a method which allows flushing to disk as the document is assembled?
Yes, the complete document will be loaded in to the memory to save it.
Is the Aspose memory footprint larger or smaller than POI's with similarly sized documents?
Well, I am not sure about the POI’s features. But you may test Aspose.Cells by downloading the evaluation version from the following location and check it by yourself.
You may check the online documentation for your reference:
Aspose.Cells for Java Docs
You may check our online demos:
What is the behaviour of Aspose when an outOfMemory exception is encountered?
Well, it depend on you how you handle this exception at your end. You may increase the available memory of JVM to overcome any such issue. You may extend the JVM memory appropriately to run your code for creating the big file. Following is the command line if you can make use of it:
java -Xms1000m -Xmx1000m MyTest ......... you may allot more memory appropriately.
Please feel free to contact us if you have any further query. We will be happy to help you out.
Thank You & Best Regards,