• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

Read MS Excel Sheet Formula Execution Value Without Opening it

 
Greenhorn
Posts: 14
IntelliJ IDE Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The tag worked ;-)
My first success.

G.


 
Joshi Nirav
Greenhorn
Posts: 14
IntelliJ IDE Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
The harder I work, the luckier I get. -Sam Goldwyn So tiny. - this ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic