Cancel a calculation

The following example shows you how to cancel a long running calculation. The engine checks CalcOptions.CancellationToken throughout evaluation and aborts the run with an OperationCanceledException when the token is cancelled, which keeps a server responsive when a large workbook arrives.

C# example

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

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

            CancellationTokenSource source = new CancellationTokenSource();
            source.CancelAfter(TimeSpan.FromSeconds(30));

            CalcSession session = new CalcSession();
            session.Options.CancellationToken = source.Token;

            try
            {
                CalcResult result = session.Calculate(book);
                Console.WriteLine(result);
            }
            catch (OperationCanceledException)
            {
                Console.WriteLine("Calculation cancelled.");
            }
        }
    }
}

VB example

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

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

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

        Dim source As New CancellationTokenSource()
        source.CancelAfter(TimeSpan.FromSeconds(30))

        Dim session As New CalcSession()
        session.Options.CancellationToken = source.Token

        Try
            Dim result As CalcResult = session.Calculate(book)
            Console.WriteLine(result)
        Catch ex As OperationCanceledException
            Console.WriteLine("Calculation cancelled.")
        End Try

    End Sub
End Module

Calc .NET > Tutorial > Cancel a calculation

Need help? Ask our developers: