Excel.Interfaces.FilterPivotHierarchyUpdateData interface

An interface for updating data on the FilterPivotHierarchy object, for use in filterPivotHierarchy.set({ ... }).

Properties

enableMultipleFilterItems

Determines whether to allow multiple filter items.

name

Name of the FilterPivotHierarchy.

position

Position of the FilterPivotHierarchy.

Property Details

enableMultipleFilterItems

Determines whether to allow multiple filter items.

enableMultipleFilterItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the FilterPivotHierarchy.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

position

Position of the FilterPivotHierarchy.

position?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.8 ]