CalculatedMembers 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.

A collection of all the CalculatedMember objects on the specified PivotTable.

public interface class CalculatedMembers : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("00024454-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface CalculatedMembers : System.Collections.IEnumerable

Public Interface CalculatedMembers
Implements IEnumerable

Attributes: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

Remarks

Each CalculatedMember object represents a calculated member or calculated measure.

Use the CalculatedMembers property of the PivotTable object to return a CalculatedMembers collection.

Properties

_Default[Object]	Reserved for internal use.
Application	Returns an Application object that represents the Microsoft Excel application.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Item[Object]	Returns a single object from a collection.
Parent	Returns the parent object for the specified object.

Methods

Add(String, String, Object, Object)	Adds a calculated field or calculated item to a PivotTable.
Add2(String, Object, Object, Object, Object, Object, Object)	Reserved for internal use.
AddCalculatedMember(String, Object, Object, Object, Object, Object, Object, Object, Object)	Adds a calculated field or calculated item to a PivotTable.
GetEnumerator()

Applies to

Share via