I am using .xlsx and XSSF with POI 3.5. What should I increase the heap size to? I have tried using 1024MB for my heap max but I'm not sure how much higher I can go. And will it make a difference? I am running out of memory after 30,000 rows and I need to process over 500,000. Is there any way to flush the memory or write to a buffer? I read somewhere that you guys were going to create a separate project to handle enterprise size reporting. Was that Jasper reports? Although I downloaded iReports and set up a Jasper Report and it ran out of memory too.
John K. Borys Projects & Financial Controls Desk: 312.930.3134 [EMAIL PROTECTED] CME Group A CME/Chicago Board of Trade Company 20 S. Wacker Chicago, Illinois 60606 http://www.cmegroup.com/ -----Original Message----- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2008 10:26 AM To: POI Users List Subject: Re: Large Reports On Tue, 2 Dec 2008, Borys, John wrote: > I have been tasked with generating Enterprise Reports and writing them > to Excel Spreadsheets. When using POI, the program crashes after about > 30,000 records are processed. Try increasing your JVM heap size - the excel file format is very memory hungry to process > Excel 2007 is now capable of processing over a million rows of data. Only in .xlsx files though, .xls retains its 65k limit. XSSF (part of poi 3.5) will let you write .xslx files without the row limits Nick --------------------------------------------------------------------- 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]
