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: poi hssf translate column numbers to letters
Date Fri, 21 Jan 2005 18:37:21 GMT
> -----Original Message-----
> From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
> 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: 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