A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Software Craftsman
this week in the
Java in General
JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
Joined: May 01, 2009
Dec 14, 2011 11:19:32
I am using JExcel API, to read the contents of a existing
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.
Joined: Oct 27, 2005
Dec 14, 2011 12:49:07
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 - OCEJPAD 6
How To Ask Questions
How To Answer Questions
It is sorta covered in the
JavaRanch Style Guide
subject: JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
Creating an excel report with template having Formulae
JXL api 1.2.6 jar Formula ERROR
Read MS Excel Sheet Formula Execution Value Without Opening it
Excel formula problem
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015