Not that I know of :(
On Fri, 2004-05-21 at 07:02, Jean, Victor [IT] wrote:
> I did some additional testing and it appears that when I call
> "sheet.removeRow(row);", it clears out the row contents, but doesn't actually remove
> the row. So, I basically have a spreadsheet with 2800 blank rows eating up file
> space. Is there anyway to actually REMOVE REMOVE the row?
>
>
> -----Original Message-----
> From: Jean, Victor [IT]
> Sent: Thursday, May 20, 2004 9:15 PM
> To: POI Users List
> Subject: HELP!! Bug with Output File Size!!!
>
>
> I'm running into a bug with the file size of the outputfile.
> I have a template excel file that's about 1 megabyte in size of just plain
> unformatted data on sheet one.
> I'm reading this file in and then removing all the rows from sheet one and writing
> to a output file.
> The output file size is listed as 500K, but it has NO data at all. It is completely
> empty.
> When I go ahead and click the "Save" button in excel and close the spreadsheet, the
> size shrinks to 14K.
>
> Is this a bug or am i doing something wrong?
> Why is the output file size so big even though there's no data at all ?
>
>
> ___________________My Code Start____________________
>
> POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("c:/bigfile.xls"));
> HSSFWorkbook hssfworkbook = new HSSFWorkbook(fs);
> HSSFSheet sheet = hssfworkbook.getSheetAt(0);
>
>
> // Create outputstream for excel file
> FileOutputStream stream = new FileOutputStream("c:/smallfile.xls");
>
> int numberRows = sheet.getLastRowNum()+1;
> for (int k = 0; k < numberRows; k++)
> {
> HSSFRow row = sheet.getRow(k);
> if (row != null) {
> sheet.removeRow(row);
> }
> }
>
> hssfworkbook.write(stream);
> stream.close();
>
> ___________________My Code End______________________
>
> ---------------------------------------------------------------------
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
