Excel.Interfaces.FilterPivotHierarchyLoadOptions interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

Represents the Excel FilterPivotHierarchy.

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

Determines whether to allow multiple filter items.
id

ID of the FilterPivotHierarchy.
name

Name of the FilterPivotHierarchy.
position

Position of the FilterPivotHierarchy.

Property Details

$all

Warning

This API is now deprecated.

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

enableMultipleFilterItems

Warning

This API is now deprecated.

Determines whether to allow multiple filter items.

enableMultipleFilterItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

id

Warning

This API is now deprecated.

ID of the FilterPivotHierarchy.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Warning

This API is now deprecated.

Name of the FilterPivotHierarchy.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

position

Warning

This API is now deprecated.

Position of the FilterPivotHierarchy.

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]