Unfortunately there is no way to create an excel sheet row by row. Search the email archives for the reasons why streaming is not possible.. but in short, its because the file format contains upstream pointers to downstream data.
Regards - Avik On Mon, 2003-11-17 at 18:07, Jan Teegen wrote: > 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]
