SheetXL - v1.0.2
    Preparing search index...

    Variable PivotElementTypeConst

    PivotElementType: {
        BlankRow: "blankRow";
        FirstColumnSubheading: "firstColumnSubheading";
        FirstRowSubheading: "firstRowSubheading";
        FirstSubtotalColumn: "firstSubtotalColumn";
        FirstSubtotalRow: "firstSubtotalRow";
        PageFieldLabels: "pageFieldLabels";
        PageFieldValues: "pageFieldValues";
        SecondColumnSubheading: "secondColumnSubheading";
        SecondRowSubheading: "secondRowSubheading";
        SecondSubtotalColumn: "secondSubtotalColumn";
        SecondSubtotalRow: "secondSubtotalRow";
        ThirdColumnSubheading: "thirdColumnSubheading";
        ThirdRowSubheading: "thirdRowSubheading";
        ThirdSubtotalColumn: "thirdSubtotalColumn";
        ThirdSubtotalRow: "thirdSubtotalRow";
    } = ...

    The elements only a pivot table style has, beside the ElementTypes a pivot table also uses (all but lastHeaderCell, firstTotalCell and lastTotalCell). On a pivot table, totalRow is the grand total row and lastColumn the grand total column.

    Type Declaration

    • ReadonlyBlankRow: "blankRow"
    • ReadonlyFirstColumnSubheading: "firstColumnSubheading"
    • ReadonlyFirstRowSubheading: "firstRowSubheading"
    • ReadonlyFirstSubtotalColumn: "firstSubtotalColumn"
    • ReadonlyFirstSubtotalRow: "firstSubtotalRow"
    • ReadonlyPageFieldLabels: "pageFieldLabels"
    • ReadonlyPageFieldValues: "pageFieldValues"
    • ReadonlySecondColumnSubheading: "secondColumnSubheading"
    • ReadonlySecondRowSubheading: "secondRowSubheading"
    • ReadonlySecondSubtotalColumn: "secondSubtotalColumn"
    • ReadonlySecondSubtotalRow: "secondSubtotalRow"
    • ReadonlyThirdColumnSubheading: "thirdColumnSubheading"
    • ReadonlyThirdRowSubheading: "thirdRowSubheading"
    • ReadonlyThirdSubtotalColumn: "thirdSubtotalColumn"
    • ReadonlyThirdSubtotalRow: "thirdSubtotalRow"