PivotArea class
PivotArea class
Presents the selected area of the PivotTable.
The PivotArea type exposes the following members:
Constructors
Constructor | Description |
---|---|
init | Presents the selected area of the PivotTable. |
Properties
Property | Description |
---|---|
filters | Gets all filters for this PivotArea. |
only_data | 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. |
only_label | Indicates whether only the data labels for an item selection are selected. |
is_row_grand_included | Indicates whether the row grand total is included. |
is_column_grand_included | Indicates whether the column grand total is included. |
axis_type | Gets and sets the region of the PivotTable to which this rule applies. |
rule_type | Gets and sets the type of selection rule. |
is_outline | Indicates whether the rule refers to an area that is in outline mode. |
Methods
Method | Description |
---|---|
select_field | Select a field in the region as an area. |
select_field | Select a field in the region as an area. |
select | Select the area with filters. |
get_cell_areas | Gets cell areas of this pivot area. |
See Also
- module
aspose.cells.pivot