Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
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
Excel formula problem
Read MS Excel Sheet Formula Execution Value Without Opening it
Creating an excel report with template having Formulae
JXL api 1.2.6 jar Formula ERROR
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013