You right, it deletes row, but it does not shift other rows up.
You can then shift them up by yourself using HSSFRow.setRowNum(int
rowNum) for each row below removed.

Best regards,
Sergey Bondarenko.

2007/3/12, Khanh Tran <[EMAIL PROTECTED]>:
It just clean the row, not delete. When a row is deleted, all the following
rows will be shift up.

-----Original Message-----
From: Sergey Bondarenko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 6:23 PM
To: POI Developers List
Subject: Re: Deleting column

Hi!

I think you can use HSSFSheet.removeRow(HSSFRow row) for rows removing.

Best regards,
Sergey Bondarenko.

2007/3/12, Khanh Tran <[EMAIL PROTECTED]>:
> Dear experts,
> Is there any way to delete a column/row in Excel file using POI?
>
> Thanks.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

Reply via email to