Class PivotArea
PivotArea class
Presents the selected area of the PivotTable.
Constructors
Name | Description |
---|
PivotArea(PivotTable) | Presents the selected area of the PivotTable. |
Properties
Name | Description |
---|
AxisType { get; set; } | Gets and sets the region of the PivotTable to which this rule applies. |
Filters { get; } | Gets all filters for this PivotArea. |
IsColumnGrandIncluded { get; set; } | Indicates whether the column grand total is included. |
IsOutline { get; set; } | Indicates whether the rule refers to an area that is in outline mode. |
IsRowGrandIncluded { get; set; } | Indicates whether the row grand total is included. |
OnlyData { get; set; } | 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. |
OnlyLabel { get; set; } | Indicates whether only the data labels for an item selection are selected. |
RuleType { get; set; } | Gets and sets the type of selection rule. |
Methods
Name | Description |
---|
Select(PivotFieldType, int, PivotTableSelectionType) | Select the area with filters. |
See Also