Example usage for org.apache.poi.hssf.usermodel HSSFCell setCellFormula

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFCell setCellFormula.

Prototype

@Override
public final void setCellFormula(String formula) throws FormulaParseException, IllegalStateException

Source Link

Usage

From source file:sf.net.shawn.tools.ExcelExport.java

License:Open Source License

/**
 * //  w  w w . j  a  va 2  s.com
 * @param row
 * @param col
 * @param formula
 */
public void setFormula(short row, short col, String formula) {
    HSSFCell cell = getOrCreateCell(row, col);
    cell.setCellFormula(formula);
}

From source file:ubic.basecode.io.excel.ExcelUtil.java

License:Apache License

/**
 * @param sheet/*from w ww. ja v a 2  s  .co  m*/
 * @param row
 * @param col
 * @param value
 */
public static void setFormula(HSSFSheet sheet, int row, int col, String value) {
    HSSFRow r = sheet.getRow(row);
    if (r == null) {
        r = sheet.createRow(row);
    }
    HSSFCell c = r.createCell(col);
    c.setCellType(Cell.CELL_TYPE_FORMULA);
    c.setCellFormula(value);
}