I get an exception at this line
CellValue cellValue = evaluator.evaluate(cellDatumQG);
have furnished the code i have written..
HSSFCell cellDatumQG = rowDataQG.getCell((*short*)1);
*if* (cellDatumQG != *null*){
cellDatumQG.setCellFormula(formulaQG);
System.*out*.println("B4 HSSF");
*try*{
CellValue cellValue = evaluator.evaluate(cellDatumQG);
*switch* (cellValue.getCellType()) {
*case* HSSFCell.*CELL_TYPE_BOOLEAN*:
System.*out*.println(cellValue.getBooleanValue());
*break*;
*case* HSSFCell.*CELL_TYPE_NUMERIC*:
System.*out*.println(cellValue.getNumberValue());
*break*;
*case* HSSFCell.*CELL_TYPE_STRING*:
System.*out*.println(cellValue.getStringValue());
*break*;
*case* HSSFCell.*CELL_TYPE_BLANK*:
*break*;
*case* HSSFCell.*CELL_TYPE_ERROR*:
*break*;
// CELL_TYPE_FORMULA will never happen
*case* HSSFCell.*CELL_TYPE_FORMULA*:
*break*;
}
}
*catch*(Exception e ){
System.*out*.println("Error in HSSF Evaluator "+e.getClass()+" : "
+e.getMessage());
}
--
Hepzibah Rajulah
