org.apache.poi.hssf.util.CellReference .toString()
~ amol -----Original Message----- From: Chris Cheshire [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 6:07 PM To: POI Users List Subject: Re: Getting Alphabetic Column Name vs Number? Jon, Have a quick look through the mailing list archives for the thread titled 'poi hssf translate column numbers to letters'. This was about 3 weeks ago and one of the posts mentioned that there is indeed something in the API for this. HTH Chris Brule, Jon wrote: > Good evening, > > Being new to Jakarta POI, I have what is probably a simple question. > > I am using POI's Event API to convert an Excel document to XML. In doing > so, I am validating the data contained within the spreadsheet. I route > any error to an errors XML, which is then transformed into a user report > using XSLT. To help the user find the error, I am including the cell > reference, but I only seem to be about to get the column number from any > CellValueRecordInterface implementation. Is there a utility somewhere > within POI to convert to column number to the alphabetic column name > representation (i.e. A, B, AA, IV, etc.)? I hate to create my own > algorithm if one already exists within the POI package. > > Thanks. > > BTW, I love the Event API. It's easy to work with and fast! > > Regards, > Jon Brule > > --------------------------------------------------------------------- > 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/
