Not able to Read Formula cell value as data

[sairaj61]

Using apache poi able to read formula cell value as data but not using monitorjbl, as getCreationHelper().createFormulaEvaluator() it is unsupported . is there any other option to read formula cell value as data.

This is the link for reading derived cell value as data using apache poi https://stackoverflow.com/questions/4183708/how-to-get-the-formula-cell-valuedata-using-apache-poi

[NiharGharat]

You cannot use dataformatter here, but cell.getNumericCellValue() for numeric, for string formulas cell.getStringCellValue(), cell.getBooleanCellValue() works. For formula itself,use cell.getCellFormula()