This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Hands On Software Engineering with Python and have Brian Allbey on-line!
See this thread for details.
Win a copy of Hands On Software Engineering with Python this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

VLOOKUP with POI shows #VALUE! error  RSS feed

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using the VLOOKUP formula with HSSFWrokbook and the generated Excel file shows #VALUE! error. it says that "a value used in the formula is of the wrong data type". I dont understand it.

Code:
summaryCell.setCellFormula("VLOOKUP($F"+(tableRows+8)+",$A$8:$D$"+(resultSize+7)+",2,FALSE)");
which turns to
summaryCell.setCellFormula("VLOOKUP($F8,$A$8:$D$26,2,FALSE)");

Where $F8 column is a date value = 6/30/2011 11:25:39 AM, and it is dispalys like "6/30/2011" in F8.

It works with the String value, like if i directly provide the value e.g. summaryCell.setCellFormula("VLOOKUP(\"TOTAL\",A8:D30,4,FALSE)");
Its works fine. But it doesn't work with the reference like $F8.

Thanks in Advance !
 
Of course, I found a very beautiful couch. Definitely. And this tiny ad:
Programmatically Create PDF Using Free Spire.PDF with Java
https://coderanch.com/wiki/703735/Programmatically-Create-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!