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.

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.
Name	Inherited from DataComponentBase.
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.

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, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. 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.
GetService(Type)	Inherited from DataComponentBase.
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.

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.

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

ExcelDataSource Members

Constructors

Properties

Methods

Events