I think you should use sheet.shiftRows (int startRow, int endRow, int n) Shift all the rows (under the row you want to remove) up by one
Does this help? -----Original Message----- From: Robert Herold [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 8:16 PM To: 'POI Users List' Subject: RE: Shrink spreadsheet after removing rows? (Bump to top of communal conciousness again) Is this possible to do? Maybe it's so obvious that no one bothered to respond to such an idiotic question... Thanks for any help. -- bob -----Original Message----- From: Robert Herold [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 1:38 PM To: [email protected] Subject: Shrink spreadsheet after removing rows? Just started using poi.hssf yesterday - very nice! I'm using it to manipulate an existing spreadsheet. I want to remove a row in the middle, so I move all rows after it up by one. This leaves a blank row at the end, which one can see after writing it out and opening it with Excel. I've tried removing the blank row, to no avail. Is there any way to shrink the spreadsheet to not include the blank row? -- bob --------------------------------------------------------------------- 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/
