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.

C# example

using System;
using Independentsoft.Calc;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet1 = new Worksheet("Sheet1");
            sheet1["A1"] = new Cell(10);
            sheet1["A2"] = new Cell(20);
            sheet1["A3"] = new Cell(30);

            Cell total = new Cell();
            total.Formula = new Formula("SUM(A1:A3)");
            sheet1["A4"] = total;

            Cell average = new Cell();
            average.Formula = new Formula("AVERAGE(A1:A3)");
            sheet1["A5"] = average;

            Workbook book = new Workbook();
            book.Sheets.Add(sheet1);

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

            Console.WriteLine(result);

            Console.WriteLine("A4 = " + sheet1["A4"].Value);
            Console.WriteLine("A5 = " + sheet1["A5"].Value);

            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Calc
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet1 As New Worksheet("Sheet1")
        sheet1("A1") = New Cell(10)
        sheet1("A2") = New Cell(20)
        sheet1("A3") = New Cell(30)

        Dim total As New Cell()
        total.Formula = New Formula("SUM(A1:A3)")
        sheet1("A4") = total

        Dim average As New Cell()
        average.Formula = New Formula("AVERAGE(A1:A3)")
        sheet1("A5") = average

        Dim book As New Workbook()
        book.Sheets.Add(sheet1)

        Dim session As New CalcSession()
        Dim result As CalcResult = session.Calculate(book)

        Console.WriteLine(result)

        Console.WriteLine("A4 = " & sheet1("A4").Value)
        Console.WriteLine("A5 = " & sheet1("A5").Value)

        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

Calc .NET > Tutorial > Calculate a workbook

Need help? Ask our developers: