JAVA Excel POI API: Problem

Question

Hi All, I am using the Java POI package to access the excel files. I have an excel file for which i am updating the cell values. those values are being used in some other sheets (within the same excel file) however, when i open the file, those values don't updated. when i select the cell text and hit enter then all the remaining sheets get the value.

please suggest if I am missing something...

Thanks ABH

Answer 1

You need evaluate the formulas to update it's values. check out here:

http://poi.apache.org/spreadsheet/eval.html