WorksheetDataConnection Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

GuidAttribute InterfaceTypeAttribute

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.