Hello Lauren I have same problem we can developer together VLOOKUP? In my vacation I will try to develope VLOOKUP for POI.
But my sugestion for your problem: Can you to change layout sheet? On Dec 27, 2007 5:35 PM, Lauren Riley <[EMAIL PROTECTED]> wrote: > 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? > > > [image: Inactive hide details for Manda Wilson <[EMAIL PROTECTED]>]Manda > Wilson <[EMAIL PROTECTED]> > > > > *Manda Wilson <[EMAIL PROTECTED]>* > > 12/19/2007 02:33 PM > Please respond to > "POI Users List" <[email protected]> > > > To > > "POI Users List" <[email protected]> > cc > > > Subject > > Re: Using VLOOKUP > > 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. > -- raphael milani :=]
