Excel.Interfaces.PivotLayoutUpdateData interface

Package:

excel

An interface for updating data on the PivotLayout object, for use in pivotLayout.set({ ... }).

Remarks

Used by

• Excel.PivotLayout: set

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.

Property Details

layoutType

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";

Property Value

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

Remarks

API set: ExcelApi 1.8

showColumnGrandTotals

Specifies if the PivotTable report shows grand totals for columns.

showColumnGrandTotals?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.8

showRowGrandTotals

Specifies if the PivotTable report shows grand totals for rows.

showRowGrandTotals?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.8

subtotalLocation

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";

Property Value

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

Remarks

API set: ExcelApi 1.8