Edit

Share via

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).
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

$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

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 ]

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 ]