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