ExcelDataSource Members
#Constructors
Name | Description |
---|---|
Excel |
Initializes a new instance of the Excel |
#Properties
Name | Description |
---|---|
Can |
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. |
Design |
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. |
File |
Gets or sets a path to the Microsoft Excel workbook or CSV file. |
Name |
Inherited from Data |
Schema |
Gets the Excel |
Site | Gets or sets the ISite of the Component. Inherited from Component. |
Source |
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. |
Stream |
Gets or sets the format of the document contained in the Excel |
#Methods
Name | Description |
---|---|
Create |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Inherited from Marshal |
Dispose() | Releases all resources used by the Component. Inherited from Component. |
Dispose |
Releases the unmanaged resources used by the Component and optionally releases the managed resources. Inherited from Component. |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Fill() | Retrieves the data from the Excel data source. |
Fill |
Retrieves the data from the Excel data source with the specified parameters. |
Fill |
Populates the Excel |
Fill |
Populates the Excel |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Inherited from Marshal |
Get |
Inherited from Data |
Get |
Gets the Type of the current instance. Inherited from Object. |
Initialize |
Obtains a lifetime service object to control the lifetime policy for this instance.
Inherited from Marshal |
Load |
Loads the data source schema definition from XML. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Marshal |
Rebuild |
Updates the result schema of a data source available on the client according to the current data source structure. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Save |
Saves the XML definition of the data source schema. |
To |
Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component. |
#Events
Name | Description |
---|---|
Before |
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. |