Ok, I really need VLOOKUP, INDEX, and MATCH...So I'm going to attempt to
code them. Anybody have any helpful suggestions as to which one of the
other functions I could look at that might be close for an example?
Manda Wilson
<[EMAIL PROTECTED]
c.org> To
"POI Users List"
12/19/2007 02:33 <[email protected]>
PM cc
Subject
Please respond to Re: Using VLOOKUP
"POI Users List"
<[EMAIL PROTECTED]
org>
The INDEX and MATCH functions have not been implemented yet, so your
formula can't be evaluated.
http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/src/org/
apache/poi/hssf/record/formula/functions/Index.java
http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/src/org/
apache/poi/hssf/record/formula/functions/Match.java
You can implement them yourself (and as Nick said about VLOOKUP, if
you do send the implementations as a patch so that other people can
use them :).
Manda
On Dec 19, 2007, at 2:28 PM, Lauren Riley wrote:
> My cell value in bushelsPerFootCell is INDEX(Bushels!P13:AF67, MATCH
> (" + widthCell + ",Bushels!O13:O67,1), MATCH(" + lengthCell +
> ",Bushels!P12:AF12,1))
>
> HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(sheet,
> workbook);
> CellReference cellReference = new CellReference(bushelsPerFootCell);
>
> HSSFRow evalBushelsPerFootRow = sheet.getRow(cellReference.getRow());
> evaluator.setCurrentRow(evalBushelsPerFootRow);
> HSSFCell evalBushelsPerFootCell = evalBushelsPerFootRow.getCell
> (cellReference.getCol());
> HSSFFormulaEvaluator.CellValue cellValue = evaluator.evaluate
> (evalBushelsPerFootCell);
>
> The cellValue has a cell type of 5 - an error. What's wrong with
> what I have?
>
>
> Nick Burch <[EMAIL PROTECTED]>
>
>
> Nick Burch <[EMAIL PROTECTED]>
> 12/19/2007 09:38 AM
> Please respond to
> "POI Users List" <[email protected]>
>
> To
>
> POI Users List <[email protected]>
>
> cc
>
>
> Subject
>
> Re: Using VLOOKUP
>
>
> On Tue, 18 Dec 2007, Lauren Riley wrote:
> > If I go to the second cell's function in the textfield, and hit
> enter,
> > then the correct value displays. So I know I have the right
> formula,
> > but it's like it can't compute the second cell because it doesn't
> yet
> > have the value from the first cell lookup. Is there a way to get
> around
> > this?
>
> You could try using the formula evaluator to pre-compute the cell
> types
> and values:
> http://poi.apache.org/hssf/eval.html
>
> Otherwise, if you know the type of the data that the cell will
> hold, you
> could try forcing the setting of that yourself
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
> __________________________________________
> The information contained in this message may be privileged and
> confidential and protected from disclosure. If you are not the
> intended recipient of this message, you are hereby notified that
> any dissemination, distribution, or copying of this communication
> is strictly prohibited. If you have received this communication in
> error, please notify us immediately by replying to the message, and
> please delete it from your computer.
__________________________________________
The information contained in this message may be privileged and
confidential and protected from disclosure. If you are not the intended
recipient of this message, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us immediately
by replying to the message, and please delete it from your computer.
