POI读取Excel公式列

xiaoxiao2021-02-28  86

case HSSFCell.CELL_TYPE_FORMULA: // 公式 FormulaEvaluator evaluator = cell.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator(); evaluator.evaluateFormulaCell(cell); CellValue cellValue = evaluator.evaluate(cell); Double celldata = cellValue.getNumberValue(); strCell=String.valueOf(celldata); break; 
转载请注明原文地址: https://www.6miu.com/read-56689.html

最新回复(0)