I've just looked at shiftRows(..). It is more intellectual than simple setRowNum(..) for all rows. But maybe it's enough for you to call cell.setCellNum(..) for all cells at the left from removed cell. Is it suitable for you ?
Best regards, Sergey. 2007/3/13, Khanh Tran <[EMAIL PROTECTED]>:
Sorry for posting twice a question. I delete/insert rows fine now. After deleting/inserting, I called shiftRows to shift the affected rows. I am looking for the similar method for column, ie, shiftCells... Best regards, Khanh -----Original Message----- From: Sergey Bondarenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 3:02 PM To: POI Developers List Subject: Re: Deleting column 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/ --------------------------------------------------------------------- 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/
