Before the sheet is generated via FileOutputStream these modifications
are done.
And when the sheet is generated the rows which were supposed to be deleted
are stil there, and if they had any cell data, that data is cleared though.
Total no. of rows remain same, with the removed rows appearing as blank
rows.
Anthony Andrews wrote:
This may sound a silly question but when you say that the row is still there
what do you mean? Do you mean that when you remove the row, save the workbook
away and then open it again in Excel the row can still be seen or that if you
remove the row you can still read it in code?
--- On Wed, 7/30/08, Manav Khanna <[EMAIL PROTECTED]> wrote:
From: Manav Khanna <[EMAIL PROTECTED]>
Subject: Removing rows from HSSFSheet
To: [email protected]
Date: Wednesday, July 30, 2008, 9:55 PM
Hi
I have to remove some rows(including blank) from an HSSFSheet.
But some how the sheet.removeRow(row) api deletes the contents
of the rows but does not actually delete the row.
Any pointers how can it be done?
Thanks
---------------------------------------------------------------------
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]
