WorksheetDataConnection Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Used to import data into the Data Model from data on the worksheet such as ranges and tables.
public interface class WorksheetDataConnection[System.Runtime.InteropServices.Guid("000244D2-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface WorksheetDataConnectionPublic Interface WorksheetDataConnection- Attributes
Properties
| Application |
Returns an Application object that represents the Excel application. Read-only. |
| CommandText |
Returns or sets the command string for the specified data source. Object (object in C#) Read/Write. |
| CommandType |
Returns or sets one of the XlCmdType constants. For a WorksheetDataConnection object, this type will be set to xlCmdExcel. |
| Connection |
Returns the internal connection string to the object in Excel. Object (object in C#) Read-only. |
| Creator |
Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer (int in C#). |
| Parent |
Returns an Object (object in C#) that represents the parent object of the specified WorksheetDataConnection object. Read-only. |