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.

See also:

Pivot Assembly Interfaces