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. |
| Name | Inherited from DataComponentBase. |
| ObjectType | 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. |
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, 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. |
| RenameParameter(String, String) | Inherited from DataComponentBase. |
| RenameParameters(IDictionary<String, String>) | Inherited from DataComponentBase. |
| 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