Working with formulas

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

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();
            sheet.Name = "Formulas";

            sheet["A1"] = new Cell(10);
            sheet["A2"] = new Cell(20);
            sheet["A3"] = new Cell(30);

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

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

            Cell maxCell = new Cell();
            maxCell.Formula = new Formula("MAX(A1:A3)");
            sheet["A6"] = maxCell;

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

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

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

        Dim sheet As New Worksheet()
        sheet.Name = "Formulas"

        sheet("A1") = New Cell(10)
        sheet("A2") = New Cell(20)
        sheet("A3") = New Cell(30)

        Dim sumCell As New Cell()
        sumCell.Formula = New Formula("SUM(A1:A3)")
        sheet("A4") = sumCell

        Dim avgCell As New Cell()
        avgCell.Formula = New Formula("AVERAGE(A1:A3)")
        sheet("A5") = avgCell

        Dim maxCell As New Cell()
        maxCell.Formula = New Formula("MAX(A1:A3)")
        sheet("A6") = maxCell

        Dim ifCell As New Cell()
        ifCell.Formula = New Formula("IF(A4>50,""Large"",""Small"")")
        sheet("A7") = ifCell

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Working with formulas

Need help? Ask our developers: