Cancel a calculation

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

import java.util.Timer;
import java.util.TimerTask;
import java.util.concurrent.atomic.AtomicBoolean;

import com.independentsoft.calc.CalcCancelledException;
import com.independentsoft.calc.CalcResult;
import com.independentsoft.calc.CalcSession;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\large.xlsx");

            final AtomicBoolean token = new AtomicBoolean(false);

            Timer timer = new Timer(true);
            timer.schedule(new TimerTask()
            {
                public void run()
                {
                    token.set(true);
                }
            }, 30000);

            CalcSession session = new CalcSession();
            session.getOptions().setCancellationToken(token);

            try
            {
                CalcResult result = session.calculate(book);
                System.out.println(result);
            }
            catch (CalcCancelledException e)
            {
                System.out.println("Calculation cancelled.");
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JCalc > Tutorial > Cancel a calculation

Need help? Ask our developers: