Excel.Interfaces.DataPivotHierarchyLoadOptions interface

Package:

excel

Represents the Excel DataPivotHierarchy.

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).
field	Returns the PivotFields associated with the DataPivotHierarchy.
id	ID of the DataPivotHierarchy.
name	Name of the DataPivotHierarchy.
numberFormat	Number format of the DataPivotHierarchy.
position	Position of the DataPivotHierarchy.
showAs	Specifies if the data should be shown as a specific summary calculation.
summarizeBy	Specifies if all items of the DataPivotHierarchy are shown.

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

field

Returns the PivotFields associated with the DataPivotHierarchy.

field?: Excel.Interfaces.PivotFieldLoadOptions;

Property Value

Excel.Interfaces.PivotFieldLoadOptions

Remarks

[ API set: ExcelApi 1.8 ]

id

ID of the DataPivotHierarchy.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the DataPivotHierarchy.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

numberFormat

Number format of the DataPivotHierarchy.

numberFormat?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

position

Position of the DataPivotHierarchy.

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

showAs

Specifies if the data should be shown as a specific summary calculation.

showAs?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

summarizeBy

Specifies if all items of the DataPivotHierarchy are shown.

summarizeBy?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]