aspose file tools*
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
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: 19670
    
  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