Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / ExcelError Event
Example


In This Topic
    ExcelError Event (GcSpreadSheet)
    In This Topic
    Occurs when an error occurs during loading or saving an Excel-formatted file.
    Syntax
    'Declaration
     
    Public Event ExcelError As EventHandler(Of ExcelErrorEventArgs)
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim handler As EventHandler(Of ExcelErrorEventArgs)
     
    AddHandler instance.ExcelError, handler
    public event EventHandler<ExcelErrorEventArgs> ExcelError
    Event Data

    The event handler receives an argument of type ExcelErrorEventArgs containing data related to this event. The following ExcelErrorEventArgs properties provide information specific to this event.

    PropertyDescription
    An ExcelWarning instance used to provide error details.  
    Example
    This example uses the ExcelError event.
    private void gcSpreadSheet1_EditChange(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
            {
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.Row.ToString());
            }
    
    private void gcSpreadSheet1_EditEnd(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs e)
            {
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.Row.ToString());
            }
    
    private void gcSpreadSheet1_EditStarting(object sender, GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs e)
            {
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.Row.ToString());
            }
    
    private void gcSpreadSheet1_ExcelError(object sender, GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs e)
            {
                listBox1.Items.Add(e.ExcelWarning.Code.ToString());
            }
    Private Sub GcSpreadSheet1_EditChange(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditChange
            ListBox1.Items.Add(e.Column.ToString())
            ListBox1.Items.Add(e.Row.ToString())
        End Sub
    
    Private Sub GcSpreadSheet1_EditEnd(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellEventArgs) Handles GcSpreadSheet1.EditEnd
            ListBox1.Items.Add(e.Column.ToString())
            ListBox1.Items.Add(e.Row.ToString())
        End Sub
    
    Private Sub GcSpreadSheet1_EditStarting(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EditCellStartingEventArgs) Handles GcSpreadSheet1.EditStarting
            ListBox1.Items.Add(e.Column.ToString())
            ListBox1.Items.Add(e.Row.ToString())
        End Sub
    
    Private Sub GcSpreadSheet1_ExcelError(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.Data.ExcelErrorEventArgs) Handles GcSpreadSheet1.ExcelError
            ListBox1.Items.Add(e.ExcelWarning.Code.ToString())
        End Sub
    See Also