poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amol Deshmukh <adeshm...@hobsons-us.com>
Subject RE: Getting Alphabetic Column Name vs Number?
Date Wed, 16 Feb 2005 13:26:48 GMT
org.apache.poi.hssf.util.CellReference

.toString()

~ amol

-----Original Message-----
From: Chris Cheshire [mailto:ccheshire@bigredwire.com]
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: 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/

---------------------------------------------------------------------
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/


Mime
View raw message