Hi karl, that does work, but I am actually looking for a better way of doing it programatically, so that I don't have to hold on to this huge data in memory and write it at the end. I cud do a chunk write, close and open the file, then append the next chunk, but I don't want to get into that...that will just make it slower.
-----Original Message----- From: KHZ (SAW) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 2:48 AM To: 'POI Users List' Subject: AW: Out of memory Hi Pillai. Increase the JavaVM via e.g. -Xmx256m (applicable for Tomcat and Eclipse - there main() specific; on different platforms maybe a bit different). Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Pravin Pillai [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 22. September 2004 22:35 An: POI Users List Betreff: Out of memory I am experiencing "out of memory" issue with POI. I am doing an export operation and dealing with huge data. And I think maybe it has got to do with the large number of HSSFCells being created. Right now I do a single workbook.write() at the end of the operation. Is there a way I could do the write in chunks or any other ideas to improve the performance. Has anybody else experienced these issues before. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
