my dog learned polymorphism*
The moose likes Other Open Source Projects and the fly likes Read MS Excel Sheet Formula Execution Value Without Opening it 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 » Products » Other Open Source Projects
Bookmark "Read MS Excel Sheet Formula Execution Value Without Opening it" Watch "Read MS Excel Sheet Formula Execution Value Without Opening it" New topic
Author

Read MS Excel Sheet Formula Execution Value Without Opening it

Joshi Nirav
Greenhorn

Joined: Dec 04, 2009
Posts: 14

Hi all,
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 ?

Thanks and Regards
Nirav Joshi
Geoff Jefferson
Ranch Hand

Joined: Apr 09, 2009
Posts: 102
Hello,

I can't help you but there is an Apache POI forum that might be more
appropriate than this list. The URL Is...

Apache POI

or

... not sure if URL tag.

http://apache-poi.1045710.n5.nabble.com/

G


Geoff Jefferson
Ranch Hand

Joined: Apr 09, 2009
Posts: 102
The tag worked ;-)
My first success.

G.


Joshi Nirav
Greenhorn

Joined: Dec 04, 2009
Posts: 14

Hi all,
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 ?

Thanks and Regards
Nirav Joshi
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Read MS Excel Sheet Formula Execution Value Without Opening it
 
Similar Threads
Accessing Date columns from Excel worksheets
opening an existing excel file on local
JExcelApi - read a cell that contains a formula, but want to read the calculated value of the formul
Converting special characters to hex code
How to read a Date column from an Excel sheet using Apache POI