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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 19541
    
  16

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
Creating an excel report with template having Formulae
Read MS Excel Sheet Formula Execution Value Without Opening it
JExcel Help
Excel formula problem
JXL api 1.2.6 jar Formula ERROR