PivotArea class

PivotArea class

Presents the selected area of the PivotTable.

The PivotArea type exposes the following members:

Constructors

ConstructorDescription
initPresents the selected area of the PivotTable.

Properties

PropertyDescription
filtersGets all filters for this PivotArea.
only_dataIndicates 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_labelIndicates whether only the data labels for an item selection are selected.
is_row_grand_includedIndicates whether the row grand total is included.
is_column_grand_includedIndicates whether the column grand total is included.
axis_typeGets and sets the region of the PivotTable to which this rule applies.
rule_typeGets and sets the type of selection rule.
is_outlineIndicates whether the rule refers to an area that is in outline mode.

Methods

MethodDescription
selectSelect the area with filters.

See Also