Skip to main content

ASPxDashboard.ExcelDataSourceBeforeFill 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.DashboardWeb

Assembly: DevExpress.Dashboard.v22.1.Web.WebForms.dll

Declaration

public event ExcelDataSourceBeforeFillWebEventHandler ExcelDataSourceBeforeFill

Event Data

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

Property Description
DashboardId Gets the identifier of the dashboard for which the event was raised.
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 ExcelDataSourceBeforeFill event is raised for dashboards supplied with data using DashboardExcelDataSource and provides the capability 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).

See Also