SnapDocument.BeforeFillExcelDataSource Event
Occurs before data is extracted from the Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.
Namespace: DevExpress.Snap.Core.API
Assembly: DevExpress.Snap.v21.2.Core.dll
NuGet Package: DevExpress.Snap.Core
Declaration
Event Data
The BeforeFillExcelDataSource event's data class is BeforeFillEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| FileName | Gets or sets a path to the Microsoft Excel workbook or CSV file. |
| SourceOptions | Gets or sets options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files. |
| Stream | Gets or sets a stream that contains a Microsoft Excel workbook or CSV file. |
| StreamDocumentFormat | Gets or sets the format of the document contained in the BeforeFillEventArgs.Stream. |
Remarks
The BeforeFillExcelDataSource event allows you to change settings related to loading the Microsoft Excel workbook (XLS, XLSX or XLSM files) or CSV file. For instance, you can specify a new file path (BeforeFillEventArgs.FileName) or change options used to extract data (BeforeFillEventArgs.SourceOptions).