Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 1796 invoked from network); 19 Dec 2007 14:37:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Dec 2007 14:37:18 -0000 Received: (qmail 90964 invoked by uid 500); 19 Dec 2007 14:37:04 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 90947 invoked by uid 500); 19 Dec 2007 14:37:04 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 90937 invoked by uid 99); 19 Dec 2007 14:37:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Dec 2007 06:37:04 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ramilani@gmail.com designates 64.233.182.184 as permitted sender) Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Dec 2007 14:36:52 +0000 Received: by nf-out-0910.google.com with SMTP id c7so1705791nfi.35 for ; Wed, 19 Dec 2007 06:36:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=qhXwSFLrN7mlaqrUcZi8Iy5kbCipV5uidOtSRBafU+k=; b=ZvmBNOojoAuP8Fih9ObSI4Fju2WlCwGTe0WD6sAQnadks+ySuNbz4ybZqC79dxTecdFfIlsmOnPNW7VH5KRNwQpo6z0Ar2TLkO9QIAXKzKBo2i1RYQYx8kYSLQ1tn0hZ518hgFXCVZKY6EHe7SLNsz2tNxFCATlwBb6lVsdDOWo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=wh3+YGyb0JXRqA0hbJJN19n2G0h8uvL4S3dpNz7lBUsM7oy5ONEkJLNkFAP072XZm3L6I6mLsNs2Ijic4szHIpR4SinG6vc9kTPHK2sBQWkx7KZcNAO/BpxYxVZVyWUcMjEju8FDk6zTQLAxGfmUVUPPRxyFbMK82wNXTKlJ5uU= Received: by 10.78.133.2 with SMTP id g2mr3456082hud.26.1198075004741; Wed, 19 Dec 2007 06:36:44 -0800 (PST) Received: by 10.78.171.8 with HTTP; Wed, 19 Dec 2007 06:36:44 -0800 (PST) Message-ID: Date: Wed, 19 Dec 2007 11:36:44 -0300 From: ramilani12 To: user@poi.apache.org Subject: POI Support VLOOKUP? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16610_12846807.1198075004726" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_16610_12846807.1198075004726 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello Folks The API POI support VLOOKUP? I try to reading sheet and one cell have a VLOOKUP for example: VLOOKUP(C6,Munic IBGE!$B$4782:$C$5426,2,FALSE) But API don't understand this VLOOKUP, when I reading sheet I verify this cell and API understand this VLOOKUP is a formula but when I try to evaluate a I receive this exception: Formula VLOOKUP(C6,Munic-IBGE!$B$4782:$C$5426,2,0) *java.lang.IllegalArgumentException*: Invalid Formula cell reference: 'MUNIC' at org.apache.poi.hssf.util.CellReference.(*CellReference.java :48*) at org.apache.poi.hssf.record.formula.ReferencePtg.(* ReferencePtg.java:54*) at org.apache.poi.hssf.model.FormulaParser.Ident(*FormulaParser.java :317*) at org.apache.poi.hssf.model.FormulaParser.Factor(*FormulaParser.java :505*) at org.apache.poi.hssf.model.FormulaParser.Term(*FormulaParser.java :606*) at org.apache.poi.hssf.model.FormulaParser.Expression(* FormulaParser.java:654*) at org.apache.poi.hssf.model.FormulaParser.Arguments(* FormulaParser.java:479*) at org.apache.poi.hssf.model.FormulaParser.function(* FormulaParser.java:341*) at org.apache.poi.hssf.model.FormulaParser.Ident(*FormulaParser.java :280*) at org.apache.poi.hssf.model.FormulaParser.Factor(*FormulaParser.java :505*) at org.apache.poi.hssf.model.FormulaParser.Term(*FormulaParser.java :606*) at org.apache.poi.hssf.model.FormulaParser.Expression(* FormulaParser.java:654*) at org.apache.poi.hssf.model.FormulaParser.parse(*FormulaParser.java :758*) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate (*HSSFFormulaEvaluator.java:296*) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(* HSSFFormulaEvaluator.java:223*) at br.com.gvt.anatel.planilha.PlantaServico.parseCodMunicipio(* PlantaServico.java:135*) at br.com.gvt.anatel.planilha.PlantaServico.createUploadControle(* PlantaServico.java:91*) at br.com.gvt.anatel.planilha.PlantaServico.main(*PlantaServico.java :223*) This exception indicate this cell reference MUNIC don't localized. In my Formula: VLOOKUP(C6,Munic IBGE!$B$4782:$C$5426,2,FALSE) Munic IBGE is other sheet in my file XLS. Somebody help me? -- raphael milani :=] ------=_Part_16610_12846807.1198075004726--