测试POI的formula方法

点击(此处)折叠或打开

1. public static void formula() throws Exception{
   
2.         Workbook workbook = new HSSFWorkbook();
   
3.         Sheet sheet = workbook.createSheet("formula");
   
4.         Row row1 = sheet.createRow(0);
   
5.         Row row2 = sheet.createRow(1);
   
6.         Row row3 = sheet.createRow(2);
   
7. 
   
8.         Cell cell1 = row1.createCell(0);
   
9.         cell1.setCellValue("A=");
   
10.         Cell cell2 = row1.createCell(1);
    
11.         cell2.setCellValue(2);
    
12. 
    
13.         Cell cell3 = row2.createCell(0);
    
14.         cell3.setCellValue("B=");
    
15.         Cell cell4 = row2.createCell(1);
    
16.         cell4.setCellValue(4);
    
17. 
    
18.         Cell cell5 = row3.createCell(0);
    
19.         cell5.setCellValue("Sum=");
    
20.         Cell cell6 = row3.createCell(1);
    
21.         cell6.setCellType(Cell.CELL_TYPE_FORMULA);
    
22.         cell6.setCellFormula("SUM(B1:B2)");
    
23. 
    
24.         workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();
    
25.         FileOutputStream fileOutputStream = new FileOutputStream(new File("c:/a.xlsx"));
    
26.         workbook.write(fileOutputStream);
    
27.         fileOutputStream.close();
    
28.         System.out.println("执行成功");
    
29.     }

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30046312/viewspace-2150671/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30046312/viewspace-2150671/