poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <David.Ventimig...@wellsfargo.com>
Subject poi hssf translate column numbers to letters
Date Thu, 20 Jan 2005 19:50:21 GMT

First, thank you thank you thank you for creating POI.  It really is terrific.

However, I have a question.  How do I get the Excel column "letter" for a column?  I think
I need it to set formulas (e.g. "SUM(A2:A3)"), but HSSF seems to assume columns are created
and referenced numberically.  How do I get from POI/HSSF the fact that column #25 is the same
as column "AA" (I think...I might be off by one, but you get the picture)?  Thanks!!

David A. Ventimiglia

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/

View raw message