DashboardDesigner.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.DashboardWin

Assembly: DevExpress.Dashboard.v23.2.Win.dll

NuGet Package: DevExpress.Win.Dashboard

Declaration

C#

public event ExcelDataSourceBeforeFillEventHandler AsyncExcelDataSourceBeforeFill

VB.NET

Public Event AsyncExcelDataSourceBeforeFill As ExcelDataSourceBeforeFillEventHandler

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. Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
DataSourceConnectionName	Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
DataSourceName	Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
FileName	Gets or sets a path to the Microsoft Excel workbook or CSV file. Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
SourceOptions	Gets or sets options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files. Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
Stream	Inherited from DashboardExcelDataSourceBeforeFillEventArgs.
StreamDocumentFormat	Inherited from DashboardExcelDataSourceBeforeFillEventArgs.

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 (DashboardExcelDataSourceBeforeFillEventArgs.FileName) or change options used to extract data (DashboardExcelDataSourceBeforeFillEventArgs.SourceOptions).

Implements

AsyncExcelDataSourceBeforeFill