SpreadsheetControl.BeforeImport Event

Occurs before a document is loaded (imported from an external source).

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

public event BeforeImportEventHandler BeforeImport

VB.NET

Public Event BeforeImport As BeforeImportEventHandler

Event Data

The BeforeImport event's data class is SpreadsheetBeforeImportEventArgs. The following properties provide information specific to this event:

Property	Description
DocumentFormat	Gets the format of the document being imported.
Options	Provides access to options specific to import.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BeforeImport event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-open-a-password-protected-xls-file-t162440/CS/PasswordToOpenSample/Form1.cs#L12

InitializeComponent();
spreadsheetControl1.BeforeImport+=spreadsheetControl1_BeforeImport;
spreadsheetControl1.InvalidFormatException+=spreadsheetControl1_InvalidFormatException;

VB.NET

how-to-open-a-password-protected-xls-file-t162440/VB/PasswordToOpenSample/Form1.vb#L14

InitializeComponent()
AddHandler spreadsheetControl1.BeforeImport, AddressOf spreadsheetControl1_BeforeImport
AddHandler spreadsheetControl1.InvalidFormatException, AddressOf spreadsheetControl1_InvalidFormatException