Excel.Interfaces.PivotLayoutLoadOptions interface

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 ]