Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

evaluation of formula cell value in xls poi

 
ganesh b pol
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is your actual problem?
 
ganesh b pol
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
kindly provide response to this thread
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic