Saved Bookmarks
| 1. |
How Will You Add A Sqrt 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("SQRT(C2)" ); cell = row.createCell(3); cell.setCellValue("SQRT(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("SQRT(C2)" ); cell = row.createCell(3); cell.setCellValue("SQRT(C2)"); |
|