Saved Bookmarks
| 1. |
How Will You Add A Fact 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("FACT(C2)" ); cell = row.createCell(3); cell.setCellValue("FACT(C2)"); XSSFCell.CELL_TYPE_FORMULA can be used to the cell as formula cell. // Create SUM formula cell.setCellType(XSSFCell.CELL_TYPE_FORMULA); cell.setCellFormula("FACT(C2)" ); cell = row.createCell(3); cell.setCellValue("FACT(C2)"); |
|