File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
It's not a secret anymore!