Excel.Interfaces.PivotLayoutLoadOptions interface

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

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

autoFormat?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

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

enableFieldList?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.10 ]

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

layoutType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

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

Remarks

[ API set: ExcelApi 1.9 ]

Specifies if the PivotTable report shows grand totals for columns.

showColumnGrandTotals?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies if the PivotTable report shows grand totals for rows.

showRowGrandTotals?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

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

subtotalLocation?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]