WorksheetDataConnection WorksheetDataConnection WorksheetDataConnection Interface

Definition

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 WorksheetDataConnection
Public Interface WorksheetDataConnection
Attributes

Properties

Application Application Application

Returns an Application object that represents the Excel application. Read-only.

CommandText CommandText CommandText

Returns or sets the command string for the specified data source. Object (object in C#) Read/Write.

CommandType CommandType CommandType

Returns or sets one of the XlCmdType constants. For a WorksheetDataConnection object, this type will be set to xlCmdExcel.

Connection Connection Connection

Returns the internal connection string to the object in Excel. Object (object in C#) Read-only.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer (int in C#).

Parent Parent Parent

Returns an Object (object in C#) that represents the parent object of the specified WorksheetDataConnection object. Read-only.

Applies to