Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.Interfaces.DataPivotHierarchyLoadOptions interface

Package:
excel

Represents the Excel DataPivotHierarchy.

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).
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 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

field

Returns the PivotFields associated with the DataPivotHierarchy.

field?: Excel.Interfaces.PivotFieldLoadOptions;

Property Value

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

Feedback

Was this page helpful?