You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Brule, Jon" <Jo...@xerox.com> on 2005/02/15 23:55:20 UTC
Getting Alphabetic Column Name vs Number?
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Getting Alphabetic Column Name vs Number?
Posted by Chris Cheshire <cc...@bigredwire.com>.
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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/