aspose.cells

aspose.cells

Class PivotArea

Presents the selected area of the PivotTable.

Constructor Summary
PivotArea(table)
Presents the selected area of the PivotTable.
 
Method Summary
functionselect(axisType, fieldPosition, selectionType)
Select the area with filters.
 

    • Constructor Detail

      • PivotArea

        function PivotArea(table)
        Presents the selected area of the PivotTable.
        Parameters:
        table: PivotTable -

    • Method Detail

      • select

        function select(axisType, fieldPosition, selectionType)
        Select the area with filters.
        Parameters:
        axisType: Number - A PivotFieldType value. The region of the PivotTable to which this rule applies.
        fieldPosition: Number - Position of the field within the axis to which this rule applies.
        selectionType: Number - A PivotTableSelectionType value. Specifies what can be selected in a PivotTable during a structured selection.