Edit

Excel.Interfaces.FilterPivotHierarchyLoadOptions interface

  • Reference
Package:
excel

Represents the Excel FilterPivotHierarchy.

Remarks

[ API set: ExcelApi 1.8 ]

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

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

enableMultipleFilterItems

Determines whether to allow multiple filter items.

enableMultipleFilterItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

id

ID of the FilterPivotHierarchy.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the FilterPivotHierarchy.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

position

Position of the FilterPivotHierarchy.

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]