Jan, I aked basically the same question a few weeks ago: http://www.mail-archive.com/[EMAIL PROTECTED]/msg03092.html
The short answer seems to be "no", because of the way records are cross-referenced in an Excel file. Best regards, Robert Lowe http://RMLowe.com/ -----Original Message----- From: Jan Teegen [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:38 PM To: [EMAIL PROTECTED] Subject: OutOfMemoryError at large Excel Sheets Hello, i want to create an Excel file with 36 columns and 33168 rows out of my database. i guess that are amount 1,2 millon cells. When i want to create an Excel File with these number of cells i'll become an error: java.lang.OutOfMemoryError i know that this failure occurs because my programm creates 1,2 million cells (and HSSFCell-Object). Now my question. Is it possible to create an Excel-File row by row. Now i create a workbook, then a sheet, row and cells. not until all cells are created i write the workbook in the file. is there any alternative to put row after row into the Excel-File. So i don't need to create 1,2 million objects of HSSFCell ? Thanks Jan Teegen --------------------------------------------------------------------- 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]
