It's not a secret anymore!
The moose likes Other Open Source Projects and the fly likes JExelApi read formulaNumberValue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JExelApi read formulaNumberValue" Watch "JExelApi read formulaNumberValue" New topic

JExelApi read formulaNumberValue

Frank Hamilton

Joined: Jan 19, 2011
Posts: 21
Hi ,

I have a problem with an write/read test with jexel api.
How can I get the formula cell value if I change its variables value with this api.

This is my test :

Formula value for A5 is =SUM(A1:A4)

Although the program change the value of A1,A2,A3,A4 , the A5 value that I get is the old value before change.

Any idea,

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
jExcelApi is a library for reading and writing XLS files, not a spreadsheet engine that can evaluate formulas.

Apache POI (the other notable library for handling Excel files) has a formula evaluator that I think could be used for this.
Frank Hamilton

Joined: Jan 19, 2011
Posts: 21
Thank so much.

I agree. Here's the link:
subject: JExelApi read formulaNumberValue
It's not a secret anymore!