• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Read MS Excel Sheet Formula Execution Value Without Opening it

 
Greenhorn
Posts: 14
IntelliJ IDE Spring Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic