ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Reading and Writing Excel Files with POI
Subject:   poi not updating the values with formulas
Date:   2010-08-31 13:02:55
From:   mastmast
Hi All,


I am working on the apache poi and I have having trouble in dealing with macros.
I have a main file and a reference file. Through programming, I pass the file in input file and then create a workbook with preserve nodes set to true. Then, I replace D5 cell by getting a value from a reference file and do workbook.write(). Now there are other cells in the workbook sheet that use the value in D5 cell. So, when I replace it, the other cell values that should change, does not change but after manually opening the file and double clicking on the D5 cell, every value is updated. So I would like to know if there is a way to change the other cell values on the fly.


I would really appreciate your response to my request.


Thanks