Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

VLOOKUP with POI shows #VALUE! error

 
Jay Vaghela
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 !
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic