ExcelDataSource Members

The data source that extracts data from Microsoft Excel workbooks or CSV files.

Constructors

Name Description
ExcelDataSource() Initializes a new instance of the ExcelDataSource class.

Properties

Name Description
CanRaiseEvents protected Gets a value indicating whether the component can raise an event. Inherited from Component.
Container Gets the IContainer that contains the Component. Inherited from Component.
DesignMode protected Gets a value that indicates whether the Component is currently in design mode. Inherited from Component.
Events protected Gets the list of event handlers that are attached to this Component. Inherited from Component.
FileName Gets or sets a path to the Microsoft Excel workbook or CSV file.
Schema Gets the ExcelDataSource schema.
Site Gets or sets the ISite of the Component. Inherited from Component.
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 ExcelDataSource.Stream.

Methods

Name Description
CreateObjRef(Type) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject.
Dispose() Releases all resources used by the Component. Inherited from Component.
Dispose(Boolean) protected Releases the unmanaged resources used by the Component and optionally releases the managed resources. Inherited from Component.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Fill() Retrieves the data from the Excel data source.
Fill(IEnumerable<IParameter>) Retrieves the data from the Excel data source with the specified parameters.
FillAsync() Populates the ExcelDataSource in an asynchronous manner.
FillAsync(CancellationToken) Populates the ExcelDataSource in an asynchronous manner and uses the cancellationToken parameter to send the cancellation signal.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetLifetimeService() Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject.
GetType() Gets the Type of the current instance. Inherited from Object.
InitializeLifetimeService() Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject.
LoadFromXml(XElement) Loads the data source schema definition from XML.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protected Creates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
RebuildResultSchema() Updates the result schema of a data source available on the client according to the current data source structure.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
SaveToXml() Saves the XML definition of the data source schema.
ToString() Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component.

Events

Name Description
BeforeFill Provides the capability to change options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.
Disposed Occurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
See Also