Excel.Interfaces.DataPivotHierarchyUpdateData interface

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

Properties

field

Returns the PivotFields associated with the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

name

Name of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

numberFormat

Number format of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

position

Position of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

showAs

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

[ API set: ExcelApi 1.8 ]

summarizeBy

Specifies if all items of the DataPivotHierarchy are shown.

[ API set: ExcelApi 1.8 ]

Property Details

field

Returns the PivotFields associated with the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

field?: Excel.Interfaces.PivotFieldUpdateData;

Property Value

name

Name of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

name?: string;

Property Value

string

numberFormat

Number format of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

numberFormat?: string;

Property Value

string

position

Position of the DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

position?: number;

Property Value

number

showAs

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

[ API set: ExcelApi 1.8 ]

showAs?: Excel.ShowAsRule;

Property Value

summarizeBy

Specifies if all items of the DataPivotHierarchy are shown.

[ API set: ExcelApi 1.8 ]

summarizeBy?: Excel.AggregationFunction | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" | "Max" | "Min" | "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" | "VarianceP";

Property Value

Excel.AggregationFunction | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" | "Max" | "Min" | "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" | "VarianceP"