java - Could not resolve external workbook name 'excel_file_name.xlsx'. Workbook environment has not been set up

Question

My Spring Boot project using Apache Poi to read data from excel file.

i use FormulaEvaluator to calculate the value of cell

FormulaEvaluator formulaEvaluator = workbook.getCreationHelper().createFormulaEvaluator();
formulaEvaluator.evaluateFormulaCell(cell)

I get the error

Could not resolve external workbook name 'excel_file_name.xlsx'. Workbook environment has not been set up.

How to resolve this issue ?

Answer 1

I have fixed this issue by using method getCachedFormulaResultType as the document org.apache.poi.ss.usermodel.Cell

CellType getCachedFormulaResultType()

Only valid for formula cells

Returns: one of (CellType.NUMERIC, CellType.STRING, CellType.BOOLEAN, CellType.ERROR) depending on the cached value of the formula

i think method evaluateFormulaCell not work because the formular reference to another workbook