This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Java in General and the fly likes JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul" Watch "JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul" New topic
Author

JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul

Rudy Rodriguez
Greenhorn

Joined: May 01, 2009
Posts: 29

I am using JExcel API, to read the contents of a existing excel file.

I am trying to read a cell that contains a formula, and displays the calculated value in that cell.

For example : 25 = (a1 * b1), where 25 is displayed in the cell.
Using JExcel API, i can read the formula in the cell, but how do i read the calculated value of the formula.



Thanks
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19656
    
  18

Cell.getContents() and NumberCell.getValue() should both return the actual value. FormulaCell.getFormula() should return the formula itself.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
 
Similar Threads
JXL api 1.2.6 jar Formula ERROR
Read MS Excel Sheet Formula Execution Value Without Opening it
JExcel Help
Excel formula problem
Creating an excel report with template having Formulae