File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 42959
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!