SnapDocument.BeforeFillExcelDataSource Event

Occurs before data is extracted from the Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.

Namespace: DevExpress.Snap.Core.API

Assembly: DevExpress.Snap.v20.1.Core.dll

Declaration

event EventHandler<BeforeFillEventArgs> BeforeFillExcelDataSource
Event BeforeFillExcelDataSource As EventHandler(Of BeforeFillEventArgs)

Event Data

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

Property Description
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 BeforeFillEventArgs.Stream.

Remarks

The BeforeFillExcelDataSource event allows you to change settings related to loading the Microsoft Excel workbook (XLS, XLSX or XLSM files) or CSV file. For instance, you can specify a new file path (BeforeFillEventArgs.FileName) or change options used to extract data (BeforeFillEventArgs.SourceOptions).

See Also