ModelChanges Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

GuidAttribute InterfaceTypeAttribute

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