How Will You Add A Power Formular To A Cell Using Apache Poi?

1.	How Will You Add A Power 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("POWER(C2:C3)" ); cell = row.createCell(3); cell.setCellValue("POWER(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("POWER(C2:C3)" ); cell = row.createCell(3); cell.setCellValue("POWER(C2:C3)");

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("POWER(C2:C3)" );

cell = row.createCell(3);

cell.setCellValue("POWER(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("POWER(C2:C3)" );

cell = row.createCell(3);

cell.setCellValue("POWER(C2:C3)");

Discussion