POI读取带有公式的Excel单元格-xssf

if(CellType.FORMULA == row.getCell(j).getCellTypeEnum()) {
try {
cellValue = String.valueOf(row.getCell(j).getStringCellValue());
} catch (IllegalStateException e) {
cellValue = String.valueOf(row.getCell(j).getNumericCellValue());
}
}

原文地址:https://www.cnblogs.com/qiujiababy/p/9367040.html