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]
