Nishant, Can you give more details as to what you mean by "read in calculated value". Maybe a snippet of your code would help better understand what you are attempting. I think I understand what you are attempting but code says it so much better than words - so if you can please post the relevant code...
Regards, ~ amol PS: If I understand you right, what you are trying should be possible by foll code: // initialize HSSFFormulaEvaluator "evaluator" CellValue cv = evaluator.evaluate(cell); // switch() on cv type and call appropriate // ...cv.getXYZValue() method and call setCellValue(..) ...But this approach wont work with current version, since: 1. (see BUG 35288) 2. HSSFFormulaEvaluator is still in development, it workfs for a limited set of formulas only. > -----Original Message----- > From: Nishant Chandra [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 09, 2005 6:43 AM > To: [email protected] > Subject: How do I read formula values?? > > > Hello > > I am writing a formula in an excel sheet but when i try to read in the > calculated value, i get an error. But if I manually open it in excel, > save it and then read the values, it works. > > Is there a task to do for updating the formula in order to get its > result if I dont want to use VB cos I dont want to create hetergenous > solution to my problem. > > > Thanks > Nishant > -- > Website: www.cse.iitb.ac.in/~nishantc > > --------------------------------------------------------------------- > 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/ > --------------------------------------------------------------------- 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/
