Working with formulas

The following example shows you how to create cells with formulas including SUM, AVERAGE, MAX and IF.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Formula;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();
            sheet.setName("Formulas");

            sheet.set("A1", new Cell(10));
            sheet.set("A2", new Cell(20));
            sheet.set("A3", new Cell(30));

            Cell sumCell = new Cell();
            sumCell.setFormula(new Formula("SUM(A1:A3)"));
            sheet.set("A4", sumCell);

            Cell avgCell = new Cell();
            avgCell.setFormula(new Formula("AVERAGE(A1:A3)"));
            sheet.set("A5", avgCell);

            Cell maxCell = new Cell();
            maxCell.setFormula(new Formula("MAX(A1:A3)"));
            sheet.set("A6", maxCell);

            Cell ifCell = new Cell();
            ifCell.setFormula(new Formula("IF(A4>50,\"Large\",\"Small\")"));
            sheet.set("A7", ifCell);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Working with formulas

Need help? Ask our developers: