aspose file tools*
The moose likes Other Open Source Projects and the fly likes evaluation of formula cell value in xls poi Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "evaluation of formula cell value in xls poi" Watch "evaluation of formula cell value in xls poi" New topic
Author

evaluation of formula cell value in xls poi

ganesh b pol
Greenhorn

Joined: Aug 20, 2008
Posts: 14
currently i am facing problem in formula evaluation

while searching the net i got following code from

http://poi.apache.org/spreadsheet/eval.html

as



here developer evaluating formula from some hardcoded B3 cell
can any one tell me way to identify this B3 cell value dynamically
[ December 11, 2008: Message edited by: ganesh b pol ]
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

What is your actual problem?


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
ganesh b pol
Greenhorn

Joined: Aug 20, 2008
Posts: 14
kindly provide response to this thread
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41880
    
  63
The question is not very clear, that's why Martijn asked for clarification. If we knew better what you're trying to achieve we might be able to help.


Ping & DNS - my free Android networking tools app
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

To clarify, what do you mean by get the B3 cell dynamically? Do you just want to pass in the Cell reference as a variable? Do you want to 'search through the sheet' and find the cell?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: evaluation of formula cell value in xls poi