Excel.Interfaces.PivotLayoutData interface

An interface describing the data returned by calling pivotLayout.toJSON().

Properties

layoutType	This property indicates the PivotLayoutType of all fields on the PivotTable. If fields have different states, this will be null.
showColumnGrandTotals	Specifies if the PivotTable report shows grand totals for columns.
showRowGrandTotals	Specifies if the PivotTable report shows grand totals for rows.
subtotalLocation	This property indicates the `SubtotalLocationType` of all fields on the PivotTable. If fields have different states, this will be `null`.

This property indicates the PivotLayoutType of all fields on the PivotTable. If fields have different states, this will be null.

layoutType?: Excel.PivotLayoutType | "Compact" | "Tabular" | "Outline";

Excel.PivotLayoutType | "Compact" | "Tabular" | "Outline"

Specifies if the PivotTable report shows grand totals for columns.

showColumnGrandTotals?: boolean;

boolean

Specifies if the PivotTable report shows grand totals for rows.

showRowGrandTotals?: boolean;

boolean

This property indicates the SubtotalLocationType of all fields on the PivotTable. If fields have different states, this will be null.

subtotalLocation?: Excel.SubtotalLocationType | "AtTop" | "AtBottom" | "Off";

Excel.SubtotalLocationType | "AtTop" | "AtBottom" | "Off"