Excel.Interfaces.PivotTableStyleCollectionLoadOptions interface

Package:

excel

Represents a collection of PivotTable styles.

Remarks

[ API set: ExcelApi 1.10 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
name	For EACH ITEM in the collection: Specifies the name of the PivotTable style.
readOnly	For EACH ITEM in the collection: Specifies if this PivotTableStyle object is read-only.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

name

For EACH ITEM in the collection: Specifies the name of the PivotTable style.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

readOnly

For EACH ITEM in the collection: Specifies if this PivotTableStyle object is read-only.

readOnly?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]