This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets 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: 19649
    
  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
 
jQuery in Action, 2nd edition
 
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
JExcel Help
Excel formula problem
Creating an excel report with template having Formulae
Read MS Excel Sheet Formula Execution Value Without Opening it