Get value by adress

[Marc Collin <co...@laboiteaprog.com>]

hi

is there a way to get cell content by its adresse ?

exemple i would like to get value of cell: A2

i checked poi api but it's like i would need to create a function to convert A 
in row and 2 in column.....

so A will be 0
and 2 will be 1

any solution?

thanks


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

Re: Get value by adress

[MSB <ma...@tiscali.co.uk>]

Have a look at the CellReference class -
http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html -
that might be what you are looking for.

Yours

Mark B


Bugzilla from collinm@laboiteaprog.com wrote:
> 
> hi
> 
> is there a way to get cell content by its adresse ?
> 
> exemple i would like to get value of cell: A2
> 
> i checked poi api but it's like i would need to create a function to
> convert A 
> in row and 2 in column.....
> 
> so A will be 0
> and 2 will be 1
> 
> any solution?
> 
> thanks
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Get-value-by-adress-tp28495708p28496434.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