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.v18.1.Web.WebForms.dll


public event ExcelDataSourceBeforeFillWebEventHandler ExcelDataSourceBeforeFill
Public Event ExcelDataSourceBeforeFill As ExcelDataSourceBeforeFillWebEventHandler

The event handler receives an argument of the ExcelDataSourceBeforeFillWebEventHandler type.

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