Provides access to data in an Excel file.
Declaration Syntax| C# | Visual Basic | Visual C++ |
public class ExcelDataConnector : FileDataConnector
Public Class ExcelDataConnector _ Inherits FileDataConnector
public ref class ExcelDataConnector : public FileDataConnector
Members| All Members | Constructors | Methods | Properties | ||
| Icon | Member | Description |
|---|---|---|
 | ExcelDataConnector(XmlNode) |
Initializes a new instance of the ExcelDataConnector class.
|
| ExcelDataConnector(String, String, String, String, CheckState) |
Initializes a new instance of the ExcelDataConnector class.
|
| Equals(Object) | (Inherited from Object.) |
 | FileName |
Gets or sets the name of the file.
(Inherited from FileDataConnector.) |
 | Finalize()()() | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode()()() | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType()()() | Gets the type of the current instance. (Inherited from Object.) |
 | GetWorkSheetNames(String) |
Gets a list containing the work sheet names of the specified workbookFilename.
|
| GetWorkSheetRangeNames(String, String, Boolean) |
Gets a list of valid ranges from the specified the work sheet.
|
| GetXMLNode(XmlNode) |
Gets an XML node containing the definition of this connector.
(Overrides DataConnector.GetXMLNode(XmlNode).) |
| Id |
Gets or sets the unique ID of the connector.
(Inherited from DataConnector.) |
| IncludeFile |
Gets or sets a value specifying whether the file should be included
into the associated project.
(Overrides FileDataConnector.IncludeFile.) |
| IsExcelInstalled()()() |
Determines whether Microsoft Excel is installed on this machine.
|
| IsRangeValid(String, String, String) |
Determines whether the specified range is a valid range
in the specified workSheetName in the work book workbookFilename.
|
| IsReadOnly |
Gets or sets a value indicating whether this instance is read-only.
(Inherited from DataConnector.) |
| IsWorkSheetValid(String, String) |
Determines whether the specified workSheetName is a valid work sheet
in the specified workbookFilename.
|
| LoadColumns(ColumnCollection%) |
Loads the data columns from the connector.
(Inherited from DataConnector.) |
| LoadColumnsImpl(ColumnCollection%) |
Loads the data columns from the connector.
(Overrides DataConnector.LoadColumnsImpl(ColumnCollection%).) |
| LoadData(ColumnCollection%, RowCollection%) |
Loads the data from the connector.
(Inherited from DataConnector.) |
| LoadDataImpl(ColumnCollection%, RowCollection%) |
Loads the data from the connector.
(Overrides FileDataConnector.LoadDataImpl(ColumnCollection%, RowCollection%).) |
| MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Name |
Gets or sets the name of the connector.
(Inherited from DataConnector.) |
| ResolvedFileName |
Gets the name of the resolved file that takes relative paths into account.
(Inherited from FileDataConnector.) |
| StoreData(ColumnCollection, RowCollection) |
Stores the data to the data source.
(Inherited from DataConnector.) |
| StoreDataImpl(ColumnCollection, RowCollection) |
Stores the data to the data source. Currently not supported.
(Overrides DataConnector.StoreDataImpl(ColumnCollection, RowCollection).) |
| ToString()()() | Returns a string that represents the current object. (Inherited from Object.) |
| WorksheetName |
Gets or sets the name of the worksheet.
|
| WorksheetRange |
Gets or sets the worksheet range.
|
RemarksMicrosoft Excel needs to be installed in order to use this connector.
Inheritance Hierarchy| Object | |||
 | DataConnector | ||
| FileDataConnector | ||
| ExcelDataConnector | ||