Hi Dan. Does it also appear if e.g. you append a sequence number to the file and thus always have a new file?
I think such a comparison should be easy to test. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Daniel de Miguel Gonz�lez [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 31. August 2004 12:52 An: [EMAIL PROTECTED] Betreff: Problem writing an Excel file several times. Hi everybody, 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]
