Edit

Share via

Excel.Interfaces.DataPivotHierarchyUpdateData interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

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

Properties

field

Returns the PivotFields associated with 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

field

Warning

This API is now deprecated.

Returns the PivotFields associated with the DataPivotHierarchy.

field?: Excel.Interfaces.PivotFieldUpdateData;

Property Value

Excel.Interfaces.PivotFieldUpdateData

Remarks

[ API set: ExcelApi 1.8 ]

name

Warning

This API is now deprecated.

Name of the DataPivotHierarchy.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

numberFormat

Warning

This API is now deprecated.

Number format of the DataPivotHierarchy.

numberFormat?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

position

Warning

This API is now deprecated.

Position of the DataPivotHierarchy.

position?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.8 ]

showAs

Warning

This API is now deprecated.

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

showAs?: Excel.ShowAsRule;

Property Value

Excel.ShowAsRule

Remarks

[ API set: ExcelApi 1.8 ]

summarizeBy

Warning

This API is now deprecated.

Specifies if all items of the DataPivotHierarchy are shown.

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"

Remarks

[ API set: ExcelApi 1.8 ]