Share via


PivotItem Members

Include Protected Members
Include Inherited Members

Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

The PivotItem type exposes the following members.

Properties

  Name Description
Public property _Default Reserved for internal use.
Public property Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Public property Caption The label text for the pivot item. Read-only String.
Public property ChildItems Returns an object that represents either a single PivotTable item (a PivotItem object) or a collection of all the items (a PivotItems object) that are group children in the specified field or children of the specified item. Read-only.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Public property DataRange Returns a Range object. Read-only.
Public property DrilledDown True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible). Read/write Boolean.
Public property Formula Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write String.
Public property IsCalculated True if the PivotTable field or PivotTable item is a calculated field or item. Read-only Boolean.
Public property LabelRange Returns a Range object that represents all the cells in the PivotTable report that contain the item. Read-only.
Public property Name Returns or sets the name of the object. Read/write String.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property ParentItem Returns a PivotItem object that represents the parent PivotTable item in the parent PivotField object (the field must be grouped so that it has a parent). Read-only.
Public property ParentShowDetail True if the specified item is showing because one of its parents is showing detail. False if the specified item isn’t showing because one of its parents is hiding detail. This property is available only if the item is grouped. Read-only Boolean.
Public property Position Position of the item in its field if the item is currently showing. Read/write Integer.
Public property RecordCount Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Integer.
Public property ShowDetail True if the outline is expanded for the specified range (so that the detail of the column or row is visible). Read/write Object.
Public property SourceName Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report. Read-only Object.
Public property SourceNameStandard Returns a String that represents the PivotTable item's source name in standard English (United States) format settings. Read-only.
Public property StandardFormula Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.
Public property Value The name of the specified item in the PivotTable field. Read/write String.
Public property Visible Determines whether the object is visible. Read/write Boolean.

Top

Methods

  Name Description
Public method Delete Deletes the object.
Public method DrillTo TheDrillTo(String) method supports drilling to a specified PivotField from a PivotItem.

Top

See Also

Reference

PivotItem Interface

Microsoft.Office.Interop.Excel Namespace