Hi,
I'm using Apache POI 3.6 for reading excel files.
Now i came to a situation where i need to evaluate a formula VLOOKUP.
When i do this with the following code:
if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
internBereikId = evaluator.evaluateFormulaCell(cell);
}
I get the runtime exception: Complex name formulas not supported yet
Is it not possible what i'm doing?
The function in excel looks like: =VLOOKUP(A2;BereikArray;3;FALSE)
where BereikArray is a validation list.
kind regards
--
View this message in context:
http://old.nabble.com/Apache-POI-excel-function-VLOOKUP-tp28779554p28779554.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
