Hi ichy
Well in fact I need to read a date for example
if in cell a1 is 17/07/1980 and the next cell I have a formula that is =a1+1
who shows 18/07/1980 in the Excel I need to read this values
Reading the first cell its easy I use getDateCellValue().toString()
but when I try to read the another cell using getNumericCellValue() I didn´t
obtain the value of the cell and when I use getCellFormula() I obtain the
formula
how can I read the value? please help me
thanks
regards,
NANCY
ichy <[EMAIL PROTECTED]> escribió:
hi Nancy.
did you try getNumericCellValue() to get the value of
the formula?
regards
ichy
2006/1/17, Nancy Espinoza :
> Hello people
>
> I have an archive in Excel who have formulas that shows values
> I need to save this values
> With POI I use the method getCellFormula()
> so it reads the formula but I need to save the value of the formula
> For example if the formula is sum(A1:A2) and the value in A1 and A2 is 1
> the result of the formula is 2
> I need to read the result 2 no sum(A1:A2)
> how can I do this?
> Please help me
> Thanks a lot
>
> Nancy
>
> __________________________________________________
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
> Regístrate ya - http://correo.espanol.yahoo.com/
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
