测试POI的formula方法

发布时间：2020-08-11 18:00:12 作者：634828354
来源：ITPUB博客阅读：231

点击(此处)折叠或打开

public static void formula() throws Exception{
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet("formula");
Row row1 = sheet.createRow(0);
Row row2 = sheet.createRow(1);
Row row3 = sheet.createRow(2);
Cell cell1 = row1.createCell(0);
cell1.setCellValue("A=");
Cell cell2 = row1.createCell(1);
cell2.setCellValue(2);
Cell cell3 = row2.createCell(0);
cell3.setCellValue("B=");
Cell cell4 = row2.createCell(1);
cell4.setCellValue(4);
Cell cell5 = row3.createCell(0);
cell5.setCellValue("Sum=");
Cell cell6 = row3.createCell(1);
cell6.setCellType(Cell.CELL_TYPE_FORMULA);
cell6.setCellFormula("SUM(B1:B2)");
workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();
FileOutputStream fileOutputStream = new FileOutputStream(new File("c:/a.xlsx"));
workbook.write(fileOutputStream);
fileOutputStream.close();
System.out.println("执行成功");
}

相关阅读