Model Model Model Interface


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

public interface class Model
public interface Model
Public Interface Model


Application Application Application

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

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#).

DataModelConnection DataModelConnection DataModelConnection

Returns the model workbook connection object from the workbook connections collection which connects to the model.

ModelRelationships ModelRelationships ModelRelationships

Returns a collection of relationships between Data Model tables. Read-only

ModelTables ModelTables ModelTables

Returns a collection of tables inside the Data Model. Read-only

Name Name Name

Returns a String (string in C#) value representing the name of the Model object. Read-only

Parent Parent Parent

Returns an Object that represents the parent object of the specified Model object. Read-only.


AddConnection(WorkbookConnection) AddConnection(WorkbookConnection) AddConnection(WorkbookConnection)

Adds a new Workbook Connection to the model with the same properties as the one supplied as an argument.

CreateModelWorkbookConnection(Object) CreateModelWorkbookConnection(Object) CreateModelWorkbookConnection(Object)

Returns a WorkbookConnection object of type ModelConnection.

Initialize() Initialize() Initialize()

Initializes the Workbook’s Data Model. This is called by default the first time the model is used.

Refresh() Refresh() Refresh()

Refreshes all data sources associated with the model, fully reprocesses the model and updates all Excel data features associated with the Model.

Applies to