My name is Daniel de Miguel, and I'm new in this mailing list. Please apologize my poor english.
I've got a problem generating a large excel file. The logical secuence is as it follows:
I create the HSSFWorkbook, y generate the data,
When I reach a condition (for example, the number of rows generated is 1000) I call the write method of the workbook.
I close the workbook.
I re-open it (I do this to avoid an OutOfMemory Exception, and it works :-D )
I continue generating...
The problem i have is that I only retrieve the information generated on the first loop.
BUT (!!!!) as i' m writing the file increases his size when i call the write method! I dont understand why the data does not apear.
Here is the code
FileOutputStream out = null;
FileInputStream in =null;
HSSFWorkbook wb = null;
HSSFSheet sheet = null;
HSSFRow row = null;
HSSFCell c = null;
while ( THERE IS MORE DATA TO GENERATE){
if (CONDITION (i.e. ROWS%1000==0)){
wb.write(out);
wb=null;
sheet=null;
row=null;
c=null;
in = new FileInputStream(pathExcel+"informeMedida"+codOpCompleja+".xls");
wb = new HSSFWorkbook(in);
sheet = wb.getSheet( "sheetname");
}
row = sheetPlaca.createRow(ROWS);
ROWS++;
c=row.createCell(0);
c.setCellValue(DATA);
/*..... Writing the data ....*/
}//while
Thank you very much.
Daniel.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
