Reading calculated data from a formula cell with formula RTD in Excel 2007 form Java application

774 views Asked by At

I am trying to evaluate the cell value of a formula cell [Formula being RTD] in Excel 2007 from my Java code. I have used HSSFFormulaEvaluator class and evaluate() method, the standard way in short. Add, subtract and other simple functions are working correctly but when I print thw CellValue object on the console returned after evaluation of function RTD, it shows '...[~FUNCTION-NOT-IMPLEMENTED~]'. I suspect POI's HSSFFormulaEvaluator hasn't yet implemented the RTD function. Nevertheless, any help or comment will be appreciated. Cheers.

0

There are 0 answers