Apache POI和EasyExcel 第六集:Apache POI的Excel读取单元格中的计算公式
一、资源
代码实现中的带有计算公式的Excel(xls)链接:/s/1-iOXn4ZnzM9eFcNbo40Gzg提取码:0916
二、代码实现
@Testpublic void testFormula() throws Exception {InputStream is = new FileInputStream(path + "计算公式.xls");HSSFWorkbook workbook = new HSSFWorkbook(is);Sheet sheet = workbook.getSheetAt(0);// 读取第五行第一列Row row = sheet.getRow(4);Cell cell = row.getCell(0);//公式计算器FormulaEvaluator formulaEvaluator = new HSSFFormulaEvaluator(workbook);// 输出单元内容int cellType = cell.getCellType();switch (cellType) {case Cell.CELL_TYPE_FORMULA://得到公式String formula = cell.getCellFormula();System.out.println(formula);CellValue evaluate = formulaEvaluator.evaluate(cell);String cellValue = evaluate.formatAsString();System.out.println(cellValue);break;case Cell.CELL_TYPE_STRING:case Cell.CELL_TYPE_BLANK:case Cell.CELL_TYPE_ERROR:case Cell.CELL_TYPE_BOOLEAN:case Cell.CELL_TYPE_NUMERIC:break;}}