Excel.Interfaces.PivotLayoutLoadOptions interface

Package:

excel

Represents the visual layout of the PivotTable.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

$all	Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
autoFormat	Specifies if formatting will be automatically formatted when it's refreshed or when fields are moved.
enableFieldList	Specifies if the field list can be shown in the UI.
layoutType	This property indicates the PivotLayoutType of all fields on the PivotTable. If fields have different states, this will be null.
preserveFormatting	Specifies if formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items.
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

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

autoFormat

Specifies if formatting will be automatically formatted when it's refreshed or when fields are moved.

autoFormat?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

enableFieldList

Specifies if the field list can be shown in the UI.

enableFieldList?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

layoutType

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

layoutType?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

preserveFormatting

Specifies if formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items.

preserveFormatting?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]