ExcelDataSource.BeforeFill Event
Provides the capability to change options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.
Namespace: DevExpress.DataAccess.Excel
Assembly: DevExpress.DataAccess.v24.2.dll
NuGet Package: DevExpress.DataAccess
#Declaration
public event EventHandler<BeforeFillEventArgs> BeforeFill
#Event Data
The BeforeFill event's data class is BeforeFillEventArgs. The following properties provide information specific to this event:
Property | Description |
---|---|
File |
Gets or sets a path to the Microsoft Excel workbook or CSV file. |
Source |
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. |
Stream |
Gets or sets the format of the document contained in the Before |
#Remarks
The BeforeFill event provides the capability 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).