*
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: 41101
    
  45
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 - my free Android networking tools app
Frank Hamilton
Greenhorn

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



 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JExelApi read formulaNumberValue
 
Similar Threads
to print a table in word(.doc file)
Excelsheet content reading
Writing a content in excel in incremental way
Read data from ExcelSheet
transfer data between Excel sheets