I looked at CellReference but it provides only numeric coordinates of the cell. I need to map column number to it's respective string expression in Excel. Thanks.
Amol Deshmukh <[EMAIL PROTECTED] To: "'POI Users List'" <poi-user@jakarta.apache.org> s-us.com> cc: Subject: RE: Inserting a row in Excel between existing rows using POI HSSF 08/08/2005 03:16 PM Please respond to "POI Users List" For #2 see: org.apache.poi.hssf.util.CellReference > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, August 08, 2005 2:42 PM > To: poi-user@jakarta.apache.org > Subject: Inserting a row in Excel between existing rows using POI HSSF > > > Sorry if I'm sending this the second time - not sure if the > first e-mail > went through: > > Hello, > I' m working with POI HSSF and looking for more help on two issues: > 1. Can someone suggest a few lines of code how to insert a new row in > Excel between existing rows using POI HSSF. > 2. May be somebody has a quick utility to determine an > alphabetic cell > column (like A1, C12) from the numeric cell number. Let's > say, if the cell > number is 32 what would be the cell letter. > > Thanks in advance. > Michael D > > > --------------------------------------------------------------------- > 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/