PivotItem Class

Represents a item in a PivotField report.

Inheritance Hierarchy

SystemObject
Aspose.Cells.PivotPivotItem

Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 22.5.0.0 (22.5.0)

Syntax

public class PivotItem

Public Class PivotItem

public ref class PivotItem

type PivotItem =  class end

The PivotItem type exposes the following members.

Properties

	Name	Description
	Index	Gets the index of the pivot item in the pivot field
	IsHidden	Gets and Sets whether the pivot item is hidden.
	IsHideDetail	Gets and Sets whether the pivot item hides detail.
	Name	Gets the name of the pivot item.
	Position	Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
	PositionInSameParentNode	Specifying the position index in the PivotItems under the same parent node.
	Value	Gets the value of the pivot item

Methods

	Name	Description
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetDateTimeValue	Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue
	GetDoubleValue	Gets the double value of the pivot item If the value is null or not number ,it will return 0
	GetHashCode	(Inherited from Object.)
	GetStringValue	Gets the string value of the pivot item If the value is null, it will return ""
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	Move	Moves the item up or down
	ToString	(Inherited from Object.)