On Sun, 29 May 2011, Rohit Sharma wrote:
I'm using Apache POI for writing spreadsheets. While the BigGridDemo works wonderfully well for XLSX files. Is there any way one can reduce the memory footprint while writing a XLS file?
Alas not - there are too many back-and-forth references between bits of the .xls file format.
But it would be nice to know if there exists any method by which we can "stream" the output without keeping all of it in memory at the same time.
Ditch the formatting and use a csv? Or stick with .xlsx! Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
