wood burning stoves 2.0*
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: 41096
    
  44
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: evaluation of formula cell value in xls poi
 
Similar Threads
Identifying in bold, italics, underline using POI
Reading only text content of the foruma cell + POI 3.5
Read a .xls,.xlsx file format using XSSF
Unable to refresh Excel formula using POI
How do i format a string to date