POI-计算公式

    @Test
    public void testFormat() throws IOException {
        //获取文件流
        FileInputStream fileInputStream = new FileInputStream("E:\\practice\\poi-test\\" + "test1.xls");
        //获取工作簿
        Workbook workbook = new HSSFWorkbook(fileInputStream);
        //获取工作表
        Sheet sheet = workbook.getSheet("表名");
        //获取行
        Row row = sheet.getRow(3);
        //获取单元格
        Cell cell = row.getCell(0);
        //获取公式字符串
        String cellFormula = cell.getCellFormula();
        System.out.println(cellFormula);

        //获取计算器
        FormulaEvaluator formulaEvaluator = new HSSFFormulaEvaluator((HSSFWorkbook)workbook);
        //执行cell内公式
        CellValue evaluate = formulaEvaluator.evaluate(cell);
        //结果转化为字符串
        String s = evaluate.formatAsString();
        System.out.println(s);


        fileInputStream.close();
    }