Hi,
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.
Below is the java code i used to get the data.
Woking code is appreable.
Rerds,
M