測試POI的formula方法
點(diǎn)擊(此處)折疊或打開
創(chuàng)新互聯(lián)致力于網(wǎng)站設(shè)計(jì)、網(wǎng)站制作,成都網(wǎng)站設(shè)計(jì),集團(tuán)網(wǎng)站建設(shè)等服務(wù)標(biāo)準(zhǔn)化，推過標(biāo)準(zhǔn)化降低中小企業(yè)的建站的成本，并持續(xù)提升建站的定制化服務(wù)水平進(jìn)行質(zhì)量交付，讓企業(yè)網(wǎng)站從市場競爭中脫穎而出。 選擇創(chuàng)新互聯(lián)，就選擇了安全、穩(wěn)定、美觀的網(wǎng)站建設(shè)服務(wù)！
-
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("執(zhí)行成功");
- }
分享標(biāo)題：測試POI的formula方法
URL地址：http://m.jiaotiyi.com/article/giiscd.html