How to get cell value of formula (data) using apache poi

Question

I am using Apache poi3.5 and java 1.6 for my application. here, I have one problem using the formula ...

my Cell has a formula (sheet2! C10), and the data inside this cell is of type String ... To access this cell, you also need to display the formula.

my Cell has a formula (sheet2! C11), and the data inside this cell is the type of number ... How to access this cell also needs to display the formula.

my Cell has a formula (sheet2! C10), and the data inside this cell is a date type ... How to access this cell and also display the formula.

Answer 1

System.out.println("Formula Cell value :" + org.apache.poi.ss.usermodel.DataFormatter dataFormatter.formatCellValue(cell, formulaEvaluator));

it will return the value of the formula cell as a string ...

Answer 2

, poi3.8.

Workbook xlsWorkbook = null;
Cell cell = null;

FormulaEvaluator formulaEval = xlsWorkbook.getCreationHelper().createFormulaEvaluator();
String value=formulaEval.evaluate(cell).formatAsString();