DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.IPivotItem

IPivotItem Interface

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.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPivotItem

Public Interface IPivotItem

Properties

Name	Description
Formula	Gets or sets the formula of calculated item.
Name	Gets or sets the name of the object (read or write).
Position	Position of the item in its field if the item is currently showing. Read/write 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).
Visible	Determines whether the object is visible (read or write).

IPivotItem Interface
Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
Properties