Edit

Share via


ModelChanges Interface

Definition

Represents changes made to the data model.

public interface class ModelChanges
[System.Runtime.InteropServices.Guid("000244E4-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ModelChanges
Public Interface ModelChanges
Attributes

Remarks

The ModelChanges object contains information about which changes were made to the data model when the ModelChange event occurs after a model operation. When Excel makes changes to the data model, multiple changes can be made in the same operation and the ModelChanges object will include information about all the changes made in one model operation.

Properties

Application

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

ColumnsAdded

Returns a ModelColumnNames collection of ModelColumnName objects which represent all columns added as part of a model operation. Read-only.

ColumnsChanged

Returns a ModelColumnChanges collection of ModelColumnChange objects which represent table names and column names of all table columns for which the data type was changed (might add more types of changes here in the future) as part of a model operation. Read-only.

ColumnsDeleted

Returns a ModelColumnNames collection of ModelColumnName objects which represent all columns which were deleted as part of a model operation. 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#).

MeasuresAdded

Returns a ModelMeasureNames collection of ModelMeasureName objects which represent all columns which were deleted as part of a model operation. Read-only.

Parent

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

RelationshipChange

When True, one or more relationships in the model were changed (added, deleted or modified) as part of a model operation. When False, no relationships were changed during the operation. Boolean (bool in C#) Read-only.

Source

The source of the data model.

TableNamesChanged

Returns a ModelTableNameChanges collection of ModelTableNameChange objects representing old and new names of all tables which were renamed in the model as part of a model operation. Read-only.

TablesAdded

Returns a ModelTableNames collection of table names as strings representing all tables which were added to the model as part of a model operation. Read-only.

TablesDeleted

Returns a ModelTableNames collection of table names as strings representing all tables which were deleted from the model as part of a model operation. Read-only.

TablesModified

Returns a ModelTableNames collection of table names as strings representing all tables which were refreshed or recalculated as part of a model operation. Read-only.

UnknownChange

True when a non-specified change was made to the model as part of a model transaction. Boolean (bool in C#) Read-only

Applies to