It's not a secret anymore!
The moose likes Other Open Source Projects and the fly likes VLOOKUP with POI shows #VALUE! error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "VLOOKUP with POI shows #VALUE! error" Watch "VLOOKUP with POI shows #VALUE! error" New topic

VLOOKUP with POI shows #VALUE! error

Jay Vaghela

Joined: Feb 15, 2006
Posts: 22
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.

which turns to

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 !
I agree. Here's the link:
subject: VLOOKUP with POI shows #VALUE! error
jQuery in Action, 3rd edition