編輯

共用方式為


PivotItem Interface

Definition

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

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.

Applies to