poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ichy <ichyli...@gmail.com>
Subject Re: HSSF POI READING FORMULAS IN AN EXCEL ARCHIVE
Date Tue, 17 Jan 2006 00:36:14 GMT
hi Nancy.

did you try getNumericCellValue() to get the value of
the formula?

regards
ichy

2006/1/17, Nancy Espinoza <nespreyes2003@yahoo.com>:
> 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: 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