PivotTableChangeList Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 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: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

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

Share via