Click or drag to resize

PivotItem Class

Represents a item in a PivotField report.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet.PivotTables PivotItem

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class PivotItem

The PivotItem type exposes the following members.

Constructors
Name Description
Public method PivotItem
Initializes a new instance of the PivotItem class with the specified parent.
Top
Properties
Name Description
Public property DrillAcross
Specifies a boolean value that indicates whether attribute hierarchies nested next to each other on a PivotTable row or column will offer drilling "across" each other or not
Public property HasChildItems
Specifies a boolean value that indicates whether the approximate number of child items for this item is greater than zero.
Public property IsCalculatedItem
Specifies a boolean value that indicates whether this item is a calculated member
Public property IsChar
Specifies a boolean value that indicates whether the item has a character value.
Public property IsExpaned
Specifies a boolean value that indicates whether this item has been expanded in the PivotTable view.
Public property IsHidden
Specifies a boolean value that indicates whether the item is hidden.
Public property IsHiddenDetails
Specifies a boolean value that indicates whether the details are hidden for this item.
Public property IsMissing
Specifies a boolean value that indicate whether the item has a missing value.
Public property ItemType
Specifies the type of the item. Value of 'default' indicates a grand total as the last row item value
Public property UserCaption
Specifies the user caption of the item.
Top
Methods
Name Description
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also