hi Nancy. did you try getNumericCellValue() to get the value of the formula?
regards ichy 2006/1/17, Nancy Espinoza <[EMAIL PROTECTED]>: > 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/
