I want to read Excel Sheet Cell value which is having formula.
I am using Apache POI 3.6 to read the Excel cell Formula Value.
I know that Apache POI apai itself is providing the FomulaEveluator to valuate the Formula but Certain Formulas are not supported by Apache POI.
So that i decided to use the Formula Cell Value without Evaluating that Specific Cell.
But the problem is in that approach is
Once i will feed the value in Cell (based on which the formula is getting calculated ) then i will try to read the value the Formula Cell Value then i won't get the calculated value.
For that i need to open the Excel in GUI mode.
But i don't want to open the Excel Sheet.
Can any one Guide to get the Solution without opening the Excel, without using the FormulaEvaluator i will get the Calculated Value of cell ?
I had done the Cell Formula Reading functionality by getting the CellReference and just read that value.
But now the issue is We need to Open the Excel Sheet by using VB macro in the backend (that mean the excel will not getting visible in UI mode) then through the VB Script we are calling the 'CalculateAll' Function of the Excel.
So that the MS Excel itself will calculate all formula without opening the Excel Sheet in UI Mode.
For Running VB Macro we need to stick with Microsoft Operating System.
But Our Client want to run on the UNIX environment.
Can anyone have a idea to achieve the same thing using Open Office API ?