PivotItem Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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.

public interface class PivotItem

[System.Runtime.InteropServices.Guid("00020876-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotItem

Public Interface PivotItem

Attributes

GuidAttribute InterfaceTypeAttribute

Remarks

Use PivotItems(index), where index is the item index number or name, to return a single PivotItem object.

Properties

_Default	Reserved for internal use.
Application	Returns an Application object that represents the Microsoft Excel application. Read-only.
Caption	The label text for the pivot item. Read-only String.
ChildItems[Object]	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.
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.
DataRange	Returns a Range object. Read-only.
DrilledDown	True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible). Read/write Boolean.
Formula	Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write String.
IsCalculated	True if the PivotTable field or PivotTable item is a calculated field or item. Read-only Boolean.
LabelRange	Returns a Range object that represents all the cells in the PivotTable report that contain the item. Read-only.
Name	Returns or sets the name of the object. Read/write String.
Parent	Returns the parent object for the specified object. Read-only.
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.
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.
Position	Position of the item in its field if the item is currently showing. Read/write Integer.
RecordCount	Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Integer.
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.
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.
SourceNameStandard	Returns a String that represents the PivotTable item's source name in standard English (United States) format settings. Read-only.
StandardFormula	Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.
Value	The name of the specified item in the PivotTable field. Read/write String.
Visible	Determines whether the object is visible. Read/write Boolean.

Methods

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