IPivotTableHeader

Assembly: Pivot;

Description

The IPivotTableHeader interface contains properties that are used to work with table headers.

Inheritance Hierarchy

IPivotTableHeader

Comments

Table header parameters can be obtained in the IPivotTable.LeftHeader (row header) and IPivotTable.TopHeader (column header) properties.

Properties

	Property name	Brief description
	DimensionElement	The DimensionElement property determines an element index of the dimension containing the table header.
	Element	The Element property returns index of an element in a dimension, to which the given table header element corresponds.
	ElementCount	The ElementCount property returns the number of elements that a table header contains.
	ElementDim	The ElementDim property returns data about dimension that is present in the table header.
	ElementDimKey	The ElementDimKey property returns key of the dimension which corresponds to the specified header element.
	ElementDimLevel	The ElementDimLevel property returns the level of dimension elements located in a specific header slot position.
	ElementLevel	The ElementLevel property returns level of the corresponding element in a dimension for the given header element.
	ElementName	The ElementName property returns name of the dimension element, to which the given table header element corresponds.
	ElementNameEx	The ElementNameEx property returns name of the dimension element, to which the given table header element corresponds, taking into account regional parameters settings.
	Group	The Group property returns index of the group that contains the given table header element.
	IsCombinedSlot	The IsCombinedSlot property returns whether there are several dimensions placed in one row and column in the table header.
	IsDimensionMergeAllowed	The IsDimensionMergeAllowed property returns whether the dimension contained in table header can be tucked.
	IsEvaluatedElement	The IsEvaluatedElement property returns whether dimension element is calculated.
	IsEvaluatedSlot	The IsEvaluatedSlot property returns whether the header element is a calculated column or row.
	IsGrouppingElement	The IsGrouppingElement property determines whether header element is a grouping one.
	IsJoinSlot	The IsJoinSlot property returns whether header element is joined by additional name.
	IsMerged	The IsMerged property returns whether an element located in a specific header slot position is tucked.
	IsPartialElement	The IsPartialElement property returns whether an element located in a specific header slot position is short.
	IsStairElement	The IsStairElement property returns whether table header element is a hierarchy stair.
	MergedDimKeys	The MergedDimKeys property returns the array of keys of the tucked element in a certain position of the header slot.
	MergedElement	The MergedElement property returns the index of tucked dimension element in a certain position of the header slot.
	SlotCount	The SlotCount property returns the number of slots, into which a table header is divided.
	SlotDim	The SlotDim property returns data of a dimension, of which elements the given header slot is formed.
	SlotDims	The SlotDims property returns the array of dimension keys located in the specified header slot.
	SlotLevel	The SlotLevel property returns the level of specific header slot.

Methods

	Method Name	Brief Description
	ContainsKey	The ContainsKey method determines whether the dimension with the specified key is present in the table header slot.
	GetSlotName	The GetSlotName method returns name of the table header slot.