ModelChanges Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 ModelChangesPublic 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 |