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
:=]
