Edit

Excel.Interfaces.FilterPivotHierarchyLoadOptions interface

Package:
excel

Represents the Excel FilterPivotHierarchy.

Remarks

API set: ExcelApi 1.8

Used by

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

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

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