I am unable to refresh formula value in Excel using POI HSSF API provided and none of the methods available in http://poi.apache.org/hssf/eval.html worked for me. May be i am doing wrong some where. Below is Excel (Report.xls) contains information Sheet Num A1B1C1 1002001/11/2008 02:40 Result A1 B1 C1 D1 E1 F1 G1 H1 ==Num!A1 =Num!B1 =Num!C1 =A1+B1 =A1-B1 =A1*B1 =A1/B1 ="Date value is "&C1
My requireent is to 1) Update A1 and B1 of "Num" sheet to 200 and 40 2) Evaluate the formulas in "Result" sheet and print the values in A1/B1/C1/D1/E1/F1/G1/H1 using java code.
Code is successfully executing but when i open excel manually, values are not updated in "Report" sheet where formulas reside. I want my java code to modify the values in formula cell.