> -----Original Message----- > From: Avik Sengupta [mailto:[EMAIL PROTECTED] > Sent: Friday, January 21, 2005 11:08 AM > To: POI Users List > Subject: RE: poi hssf translate column numbers to letters > > > There should be such a function in some util package in POI.. cant > remember where.
Indeed! Now that you point it out, this functionality has already been implemented in class org.apache.poi.hssf.util.CellReference. <TEST-CODE> CellReference cellRef = new CellReference(1, 26); String cellNumForFormula = cellRef.toString(); // cellNumForFormula equals "AA2" </TEST-CODE> Regards, ~ amol --------------------------------------------------------------------- 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/
