PivotArea Class

PivotArea class

Presents the selected area of the PivotTable.

type PivotArea struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description
NewPivotArea	Presents the selected area of the PivotTable.

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetFilters	Gets all filters for this PivotArea.
Select	Select the area with filters.
SelectField_PivotFieldType_String	Select a field in the region as an area.
SelectField_PivotFieldType_PivotField	Select a field in the region as an area.
GetOnlyData	Indicates whether only the data values (in the data area of the view) for an itemselection are selected and does not include the item labels.
SetOnlyData	Indicates whether only the data values (in the data area of the view) for an itemselection are selected and does not include the item labels.
GetOnlyLabel	Indicates whether only the data labels for an item selection are selected.
SetOnlyLabel	Indicates whether only the data labels for an item selection are selected.
IsRowGrandIncluded	Indicates whether the row grand total is included.
SetIsRowGrandIncluded	Indicates whether the row grand total is included.
IsColumnGrandIncluded	Indicates whether the column grand total is included.
SetIsColumnGrandIncluded	Indicates whether the column grand total is included.
GetAxisType	Gets and sets the region of the PivotTable to which this rule applies.
SetAxisType	Gets and sets the region of the PivotTable to which this rule applies.
GetRuleType	Gets and sets the type of selection rule.
SetRuleType	Gets and sets the type of selection rule.
IsOutline	Indicates whether the rule refers to an area that is in outline mode.
SetIsOutline	Indicates whether the rule refers to an area that is in outline mode.
GetCellAreas	Gets cell areas of this pivot area.