File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

JExelApi read formulaNumberValue

Frank Hamilton
Greenhorn

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,
thanks


Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
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.


Ping & DNS - updated with new look and Ping home screen widget
Frank Hamilton
Greenhorn

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



 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JExelApi read formulaNumberValue
 
Similar Threads
Writing a content in excel in incremental way
transfer data between Excel sheets
Excelsheet content reading
to print a table in word(.doc file)
Read data from ExcelSheet