poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ramilani12 <ramil...@gmail.com>
Subject POI Support VLOOKUP?
Date Wed, 19 Dec 2007 14:36:44 GMT
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.<init>(*CellReference.java
:48*)

      at org.apache.poi.hssf.record.formula.ReferencePtg.<init>(*
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
:=]

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message