DashboardControl.AsyncExcelDataSourceBeforeFill Event
Allows you to change options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files asynchronously.
Namespace: DevExpress.DashboardWpf
Assembly: DevExpress.Dashboard.v24.1.Wpf.dll
NuGet Package: DevExpress.Wpf.Dashboard
Declaration
Event Data
The AsyncExcelDataSourceBeforeFill event's data class is ExcelDataSourceBeforeFillEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| DataSourceComponentName | Gets the component name of the Excel data source for which the event was raised. |
| DataSourceConnectionName | |
| DataSourceName | Gets the name of the Excel data source for which the event was raised. |
| 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 ExcelDataSourceBeforeFillWpfEventArgs.Stream. |
Remarks
The AsyncExcelDataSourceBeforeFill event is raised for dashboards supplied with data using DashboardExcelDataSource and allows you to change settings related to loading the Microsoft Excel workbook (XLS, XLSX or XLSM files) or a CSV file. For instance, you can specify a new file path (ExcelDataSourceBeforeFillEventArgs.FileName) or change options used to extract data (ExcelDataSourceBeforeFillEventArgs.SourceOptions).