Saved Bookmarks
| 1. |
How Will You Add A Sum Formular To A Cell Using Apache Poi? |
|
Answer» XSSFCell.CELL_TYPE_FORMULA can be used to the cell as FORMULA cell. // Create SUM formula cell.setCellType(XSSFCell.CELL_TYPE_FORMULA); cell.setCellFormula("SUM(C2:C3)" ); cell = row.createCell(3); cell.setCellValue("SUM(C2:C3)"); XSSFCell.CELL_TYPE_FORMULA can be used to the cell as formula cell. // Create SUM formula cell.setCellType(XSSFCell.CELL_TYPE_FORMULA); cell.setCellFormula("SUM(C2:C3)" ); cell = row.createCell(3); cell.setCellValue("SUM(C2:C3)"); |
|