Built in A1-style conversion?

[Andy Ch <an...@hotmail.com>]

i've been scanning the api doc, it'd be nice if somebody can comfirm. most of
poi uses something similar to the absolute-R1C1 style reference (i.e. row 14
col 3). is there a built in converter that converts A1-style reference (i.e.
C4 or AB15) to the absolute-R1C1 style reference?

i know the code is probably not that hard to write but i thought to ask
first in case i'm reinventing the wheel

thanks in advance
Andy
-- 
View this message in context: http://www.nabble.com/Built-in-A1-style-conversion--tp16418682p16418682.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Built in A1-style conversion?

[Nick Burch <ni...@torchbox.com>]

On Tue, 1 Apr 2008, Andy Ch wrote:
> i've been scanning the api doc, it'd be nice if somebody can comfirm. 
> most of poi uses something similar to the absolute-R1C1 style reference 
> (i.e. row 14 col 3). is there a built in converter that converts 
> A1-style reference (i.e. C4 or AB15) to the absolute-R1C1 style 
> reference?

Is CellReference what you want?
http://poi.apache.org/apidocs/org/apache/poi/hssf/util/CellReference.html

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org