Edit

Share via

Excel.Interfaces.FilterPivotHierarchyData interface

  • Reference
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 ]