Edit

WorksheetDataConnection Interface

  • Reference

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.

Applies to