I think you can use the CellReference class and the formatAsString method.
http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html# formatAsString() > -----Original Message----- > From: Ramon F Herrera [mailto:[email protected]] > Sent: Tuesday, April 20, 2010 3:56 PM > To: [email protected] > Subject: How to convert zero-based cell coordinates to alphanumeric? > > > My application contains a typical formula: > > cell.cellValue = "SUM(K16:K18)"; > cell.dataFormat = FormatType.CELL_TYPE_FORMULA; > cell.contentFrmat = styles.get("2-decimal_number"); > > Let's say that the locations K16-K18 are not known until run time. Is > there some facility to convert 0-based to alphanumeric? > > It is easy enough to implement the above. I just don't want to reinvent > the wheel. > > TIA, > > -Ramon > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
