Upravit

Sdílet prostřednictvím

Model Interface

  • Reference

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.

Applies to