Read a calculated cell value

The following example shows you how to read the value of a formula cell after calculation. CalcSession writes the result into the cached value of the cell, so Cell.Value returns the calculated result while Cell.Formula still holds the formula.

C# example

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

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

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

            foreach (Worksheet sheet in book.Sheets)
            {
                foreach (Row row in sheet.Rows)
                {
                    foreach (Cell cell in row.Cells)
                    {
                        if (cell.Formula != null)
                        {
                            Console.WriteLine(sheet.Name + "!" + cell.Reference + " =" + cell.Formula.Body + " -> " + cell.Value);
                        }
                    }
                }
            }
        }
    }
}

VB example

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

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

        Dim book As New Workbook("c:\test\input.xlsx")

        Dim session As New CalcSession()
        session.Calculate(book)

        For Each sheet As Worksheet In book.Sheets
            For Each row As Row In sheet.Rows
                For Each cell As Cell In row.Cells
                    If cell.Formula IsNot Nothing Then
                        Console.WriteLine(sheet.Name & "!" & cell.Reference & " =" & cell.Formula.Body & " -> " & cell.Value)
                    End If
                Next
            Next
        Next

    End Sub
End Module

Calc .NET > Tutorial > Read a calculated cell value

Need help? Ask our developers: