PivotArea
PivotArea class
Presents the selected area of the PivotTable.
new PivotArea(table)
Presents the selected area of the PivotTable.
Methods
| Name | Description |
|---|---|
| getAxisType() | Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integ |
| getCellAreas() | |
| getFilters() | Gets all filters for this PivotArea. |
| getOnlyData() | Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not in |
| getOnlyLabel() | Indicates whether only the data labels for an item selection are selected. |
| getRuleType() | Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant. |
| isColumnGrandIncluded() | Indicates whether the column grand total is included. |
| isOutline() | Indicates whether the rule refers to an area that is in outline mode. |
| isRowGrandIncluded() | Indicates whether the row grand total is included. |
| select(axisType, fieldPosition, selectionType) | Select the area with filters. |
| selectField() | |
| selectField() | |
| setAxisType() | Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integ |
| setColumnGrandIncluded() | Indicates whether the column grand total is included. |
| setOnlyData() | Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not in |
| setOnlyLabel() | Indicates whether only the data labels for an item selection are selected. |
| setOutline() | Indicates whether the rule refers to an area that is in outline mode. |
| setRowGrandIncluded() | Indicates whether the row grand total is included. |
| setRuleType() | Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant. |
getAxisType()
Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integer constant.
getCellAreas()
getFilters()
Gets all filters for this PivotArea.
getOnlyData()
Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.
getOnlyLabel()
Indicates whether only the data labels for an item selection are selected.
getRuleType()
Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant.
isColumnGrandIncluded()
Indicates whether the column grand total is included.
isOutline()
Indicates whether the rule refers to an area that is in outline mode.
isRowGrandIncluded()
Indicates whether the row grand total is included.
select(axisType, fieldPosition, selectionType)
Select the area with filters.
| Parameter | Type | Description |
|---|---|---|
| axisType | Number | PivotFieldType |
| fieldPosition | Number | Position of the field within the axis to which this rule applies. |
| selectionType | Number | PivotTableSelectionType |
selectField()
selectField()
setAxisType()
Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integer constant.
setColumnGrandIncluded()
Indicates whether the column grand total is included.
setOnlyData()
Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.
setOnlyLabel()
Indicates whether only the data labels for an item selection are selected.
setOutline()
Indicates whether the rule refers to an area that is in outline mode.
setRowGrandIncluded()
Indicates whether the row grand total is included.
setRuleType()
Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant.