Edit

Share via

Excel.Interfaces.RowColumnPivotHierarchyCollectionLoadOptions interface

Package:
excel

Represents a collection of RowColumnPivotHierarchy items associated with 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).
id

For EACH ITEM in the collection: ID of the RowColumnPivotHierarchy.
name

For EACH ITEM in the collection: Name of the RowColumnPivotHierarchy.
position

For EACH ITEM in the collection: Position of the RowColumnPivotHierarchy.

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

id

For EACH ITEM in the collection: ID of the RowColumnPivotHierarchy.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

For EACH ITEM in the collection: Name of the RowColumnPivotHierarchy.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

position

For EACH ITEM in the collection: Position of the RowColumnPivotHierarchy.

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]