DecimalFormat decimalFormat = new DecimalFormat("####################.###########");
FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
cell.setCellFormula("SUM(K2:K6)");
String resultSTR = decimalFormat.format(evaluator.evaluate(cell).getNumberValue());
double result = Double.parseDouble(resultSTR); //避免精度丢失
poi 获取formula计算结果
于 2022-05-26 16:56:41 首次发布