Re: OutOfMemoryError at large Excel Sheets

[Avik Sengupta <av...@itellix.com>]

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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org