easypoi 导入公式获取不到 特别是date类型

Question

cn.afterturn easypoi-spring-boot-starter 3.3.0

    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.16</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.16</version>
    </dependency>

Answer 1

private static FormulaEvaluator evaluator;
// 开启强制执行表达式
evaluator=workbook.getCreationHelper().createFormulaEvaluator();
int cellType=cell.getCellType();
if(cellType==Cell.CELL_TYPE_FORMULA){ //表达式类型
cellType=evaluator.evaluate(cell).getCellType();
}