Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model.
public interface class ModelConnection
[System.Runtime.InteropServices.Guid("000244D1-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] 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.