CalculatedItems 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 PivotItem objects that represent all the calculated items in the specified PivotTable report.

public interface class CalculatedItems : System::Collections::IEnumerable

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

Public Interface CalculatedItems
Implements IEnumerable

Attributes: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

Remarks

For example, a PivotTable report that contains January, February, and March items could have a calculated item named “FirstQuarter” that is defined as the sum of the amounts in January, February, and March.

Use the CalculatedItems() method to return the CalculatedItems collection.

Use CalculatedItems(index), where index is the name or index number of the field, to return a single PivotItem object from the CalculatedItems 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.
Parent	Returns the parent object for the specified object.

Methods

_Add(String, String)	Reserved for internal use.
Add(String, String, Object)	Creates a new calculated item. Returns a PivotItem object.
GetEnumerator()
Item(Object)	Returns a single object from a collection.

Applies to