Calculate a workbook

The following example shows you how to build a workbook with formulas and calculate it with CalcSession. The cached value of every formula cell is updated in place, so the workbook can be saved with fresh results.

import com.independentsoft.calc.CalcResult;
import com.independentsoft.calc.CalcSession;
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 sheet1 = new Worksheet("Sheet1");
            sheet1.set("A1", new Cell(10));
            sheet1.set("A2", new Cell(20));
            sheet1.set("A3", new Cell(30));

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

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

            Workbook book = new Workbook();
            book.getSheets().add(sheet1);

            CalcSession session = new CalcSession();
            CalcResult result = session.calculate(book);

            System.out.println(result);

            System.out.println("A4 = " + sheet1.get("A4").getValue());
            System.out.println("A5 = " + sheet1.get("A5").getValue());

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

JCalc > Tutorial > Calculate a workbook

Need help? Ask our developers: