Edit

Share via


PivotTableChangeList Interface

Definition

Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.

public interface class PivotTableChangeList : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000244C1-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotTableChangeList : System.Collections.IEnumerable
Public Interface PivotTableChangeList
Implements IEnumerable
Attributes
Implements

Remarks

The PivotTableChangeList collection contains ValueChange objects that represent the changes a user has made to value cells in a PivotTable report. To return the PivotTableChangeList collection for a PivotTable, use the ChangeList property of the PivotTable object.

Properties

_Default[Object]
Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object.

Count

Gets a value that represents the number of objects in the collection.

Creator

Gets a 32-bit integer that indicates the application in which this object was created.

Item[Object]

Returns a single ValueChange object from the specified PivotTableChangeList collection.

Parent

Gets the parent PivotTable object for the specified PivotTableChangeList collection.

Methods

Add(String, Double, Object, Object, Object)

Adds a ValueChange object to the specified PivotTableChangeList collection.

GetEnumerator()

Applies to