Excel.Interfaces.FilterPivotHierarchyData interface

Package:

excel

An interface describing the data returned by calling filterPivotHierarchy.toJSON().

Properties

enableMultipleFilterItems	Determines whether to allow multiple filter items.
fields	Returns the PivotFields associated with the FilterPivotHierarchy.
id	ID of the FilterPivotHierarchy.
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 ]

fields

Returns the PivotFields associated with the FilterPivotHierarchy.

fields?: Excel.Interfaces.PivotFieldData[];

Property Value

Excel.Interfaces.PivotFieldData[]

Remarks

[ API set: ExcelApi 1.8 ]

id

ID of the FilterPivotHierarchy.

id?: string;

Property Value

string

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 ]