All docs
V19.2
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

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.v19.2.Win.dll

Declaration

public event ExcelDataSourceBeforeFillEventHandler AsyncExcelDataSourceBeforeFill
Public Event AsyncExcelDataSourceBeforeFill As ExcelDataSourceBeforeFillEventHandler

Event Data

The AsyncExcelDataSourceBeforeFill event handler receives an argument of the ExcelDataSourceBeforeFillEventArgs type. 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.
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 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).

Implements

DevExpress.DashboardWin.Native.IClientSideApi.AsyncExcelDataSourceBeforeFill
See Also