FreeLimitReachedAction Enumeration

public enum FreeLimitReachedAction

Public Enumeration FreeLimitReachedAction

SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial;

Stopwatch sw = new Stopwatch();

sw.Start();
ExcelFile ef = ExcelFile.Load(fileName);
sw.Stop();
Console.WriteLine("Load time: " + sw.Elapsed.TotalSeconds + " seconds.");

sw.Reset();
sw.Start();
int cellWithValueCount = 0;
foreach (var sheet in ef.Worksheets)
    foreach (var row in sheet.Rows)
        foreach (var cell in row.AllocatedCells)
            if (cell.Value != null)
                ++cellWithValueCount;
sw.Stop();
Console.WriteLine("Iterate through all used cells time: " + sw.Elapsed.TotalSeconds + " seconds. Cells with value: " + cellWithValueCount);

sw.Reset();
sw.Start();
ef.Save(fileName);
sw.Stop();
Console.WriteLine("Save time: " + sw.Elapsed.TotalSeconds + " seconds.");

SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

AddHandler SpreadsheetInfo.FreeLimitReached, Function(sender As Object, e As FreeLimitEventArgs) e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial

Dim sw = New Stopwatch()

sw.Start()
Dim ef = ExcelFile.Load(fileName)
sw.Stop()
Console.WriteLine("Load time: " & sw.Elapsed.TotalSeconds & " seconds.")

sw.Reset()
sw.Start()
Dim cellWithValueCount = 0
For Each sheet In ef.Worksheets
    For Each row In sheet.Rows
        For Each cell In row.AllocatedCells
            If Not (cell.Value Is Nothing) Then
                cellWithValueCount += 1
            End If
        Next
    Next
Next
sw.Stop()
Console.WriteLine("Iterate through all used cells time: " & sw.Elapsed.TotalSeconds & " seconds. Cells with value: " & cellWithValueCount)

sw.Reset()
sw.Start()
ef.Save(fileName)
sw.Stop()

Console.WriteLine("Save time: " & sw.Elapsed.TotalSeconds & " seconds.")