Event parameters used for the ExcelFile.LimitNear and ExcelFile.LimitReached events. (Free version only)

For a list of all members of this type, see LimitEventArgs Members.

System.Object
   System.EventArgs
      GemBox.Spreadsheet.LimitEventArgs

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Remarks

This class is present only in Free version.

Example

Following code demonstrates how to handle LimitNear and LimitReached events in GemBox.Spreadsheet Free. This sample disables warning worksheet in LimitNear event handler and displays console messages in LimitReached event handler.

[Visual Basic]
    Sub Main()
        Dim ef As ExcelFile = New ExcelFile

        AddHandler ef.LimitNear, AddressOf ef_LimitNear
        AddHandler ef.LimitReached, AddressOf ef_LimitReached

        Dim ws As ExcelWorksheet = ef.Worksheets.Add("Sheet1")

        Dim i As Integer
        For i = 0 To 172 - 1 Step i + 1
            ws.Cells(i, 0).Value = i
        Next

        ef.SaveXls("Test.xls")
    End Sub

    Private Sub ef_LimitNear(ByVal sender As Object, ByVal e As LimitEventArgs)
        e.WriteWarningWorksheet = False
    End Sub

    Private Sub ef_LimitReached(ByVal sender As Object, ByVal e As LimitEventArgs)
        Select Case e.Operation
            Case IoOperation.XlsReading
                Console.WriteLine("Data truncated while reading XLS file: " + e.FileName)

            Case IoOperation.CsvReading
                Console.WriteLine("Data truncated while reading CSV file: " + e.FileName)

            Case IoOperation.XlsWriting
                Console.WriteLine("Data truncated while writing XLS file: " + e.FileName)
                e.WriteWarningWorksheet = False

            Case IoOperation.CsvWriting
                Console.WriteLine("Data truncated while writing CSV file: " + e.FileName)

        End Select
    End Sub

[C#]
    static void Main(string[] args)
    {
        ExcelFile ef = new ExcelFile();

        ef.LimitNear += new LimitEventHandler(ef_LimitNear);
        ef.LimitReached += new LimitEventHandler(ef_LimitReached);

        ExcelWorksheet ws = ef.Worksheets.Add("Sheet1");

        for(int i=0; i!=172; i++)
            ws.Cells[i, 0].Value = i;

        ef.SaveXls("Test.xls");
    }

    private static void ef_LimitNear(object sender, LimitEventArgs e)
    {
        e.WriteWarningWorksheet = false;
    }

    private static void ef_LimitReached(object sender, LimitEventArgs e)
    {
        switch(e.Operation)
        {
            case IoOperation.XlsReading:
                Console.WriteLine("Data truncated while reading XLS file: " + e.FileName);
                break;

            case IoOperation.CsvReading:
                Console.WriteLine("Data truncated while reading CSV file: " + e.FileName);
                break;

            case IoOperation.XlsWriting:
                Console.WriteLine("Data truncated while writing XLS file: " + e.FileName);
                e.WriteWarningWorksheet = false;
                break;

            case IoOperation.CsvWriting:
                Console.WriteLine("Data truncated while writing CSV file: " + e.FileName);
                break;
        }
    }

Requirements

Namespace: GemBox.Spreadsheet

Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll)

See Also

LimitEventArgs Members | GemBox.Spreadsheet Namespace

---