ModelConnection ModelConnection ModelConnection Interface


Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model.

public interface class ModelConnection
public interface ModelConnection
Public Interface ModelConnection


To use for all PivotTables connected to the model, there will have a new “special” workbook connection which always exists (and cannot be deleted) in workbooks which have a data model. It gets created when the model is first created in a workbook. All properties on this special workbook connection are read-only. Its name is: Workbook Data Model.


ADOConnection ADOConnection ADOConnection

The ADO Connection Object is used to create an open connection to a data source. Enables addins, such as Powerview, to create a direct connection to the engine and hence the data model. ADOConnection object Read-only.

Application Application Application

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

CalculatedMembers CalculatedMembers CalculatedMembers
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. Read/Write

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 that represents the parent object of the specified ModelConnection object. Read-only.

Applies to