Assembly: Pivot;
The IPivotTableHeader interface contains properties that are used to work with table headers.
IPivotTableHeader
Table header parameters can be obtained in the IPivotTable.LeftHeader (row header) and IPivotTable.TopHeader (column header) 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. |
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. |
See also: