asposecells.api

asposecells.api

Class PivotAreaType

Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.

Field Summary
const  intNONE
No Pivot area.
const  intNORMAL
Represents a header or item.
const  intDATA
Represents something in the data area.
const  intALL
Represents the whole PivotTable.
const  intORIGIN
Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
const  intBUTTON
Represents a field button.
const  intTOP_RIGHT
Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).
 

    • Field Detail

      • NONE

        const int NONE
        No Pivot area.

      • NORMAL

        const int NORMAL
        Represents a header or item.

      • DATA

        const int DATA
        Represents something in the data area.

      • ALL

        const int ALL
        Represents the whole PivotTable.

      • ORIGIN

        const int ORIGIN
        Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).

      • BUTTON

        const int BUTTON
        Represents a field button.

      • TOP_RIGHT

        const int TOP_RIGHT
        Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).