SheetXL - v1.0.2
    Preparing search index...

    Interface PivotAreaJSON

    A part of a pivot table, as a format or a conditional format names it.

    interface PivotAreaJSON {
        axis?: IPivotTable.Axis;
        collapsedLevelsAreSubtotals?: true;
        dataOnly?: false;
        field?: number;
        fieldPosition?: number;
        grandCol?: true;
        grandRow?: true;
        labelOnly?: true;
        outline?: false;
        references?: PivotAreaReferenceJSON[];
        rest?: string;
        type?:
            | "origin"
            | "none"
            | "all"
            | "data"
            | "button"
            | "topEnd"
            | "topRight";
    }
    Index
    axis? collapsedLevelsAreSubtotals? dataOnly? field? fieldPosition? grandCol? grandRow? labelOnly? outline? references? rest? type?
    axis?: IPivotTable.Axis
    collapsedLevelsAreSubtotals?: true

    A collapsed item's line counts as its subtotal.

    dataOnly?: false

    false: labels as well as values; absent, values only.

    field?: number

    The field, by index; -2 the values. A button's field, or the field whose labels.

    fieldPosition?: number

    The field's position on its axis; absent, 0.

    grandCol?: true

    The grand total column.

    grandRow?: true

    The grand total row.

    labelOnly?: true

    Labels only.

    outline?: false

    false: tabular rather than outline positions; absent, outline.

    references?: PivotAreaReferenceJSON[]

    The cells picked, one reference per field.

    rest?: string

    The area's attributes not typed yet (offset, cacheIndex), as markup; absent, none.

    type?: "origin" | "none" | "all" | "data" | "button" | "topEnd" | "topRight"

    What kind of part, as OOXML spells it; absent, normal: the cells the references pick.

    Settings
    Member Visibility

    On This Page
    Properties