I've hit the same problem. I bumped up the heap size as much as I could. I ended up just making more small files and then manually joining them together. I wonder if the new ooxml code in 3.5 is any more efficient than the older binary method of creating excel files. Does anyone have any input on that?
Paul Dobson -----Original Message----- From: mclovin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 6:22 PM To: [email protected] Subject: Running out of memory with large Excel files Hello All, I am having issues with generating large Excel files with POI. In a nutshell, I seem to be running out of memory. The Excel file that fails is quite large - 50,000 rows, 69 columns. I have tried to increase the Java heap size for the JVM and that seems to help; but ultimately the large files still fail. Does anyone have any tips/tricks to optimize the JVM, Garbage Collection, or POI code that might help out my situation? Thanks, -Jim -- View this message in context: http://www.nabble.com/Running-out-of-memory-with-large-Excel-files-tp197 90133p19790133.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- 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]
