Model Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Stores references to workbook connections and information about the tables and relationships contained within the Data Model.

public interface class Model

[System.Runtime.InteropServices.Guid("000244DB-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Model

Public Interface Model

Attributes

GuidAttribute InterfaceTypeAttribute

Properties

Application	Returns an Application object that represents the Excel application. 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#).
DataModelConnection	Returns the model workbook connection object from the workbook connections collection which connects to the model.
ModelRelationships	Returns a collection of relationships between Data Model tables. Read-only
ModelTables	Returns a collection of tables inside the Data Model. Read-only
Name	Returns a String (string in C#) value representing the name of the Model object. Read-only
Parent	Returns an Object that represents the parent object of the specified Model object. Read-only.

Methods

AddConnection(WorkbookConnection)	Adds a new Workbook Connection to the model with the same properties as the one supplied as an argument.
CreateModelWorkbookConnection(Object)	Returns a WorkbookConnection object of type ModelConnection.
Initialize()	Initializes the Workbook’s Data Model. This is called by default the first time the model is used.
Refresh()	Refreshes all data sources associated with the model, fully reprocesses the model and updates all Excel data features associated with the Model.