Excel.Interfaces.DataPivotHierarchyUpdateData interface

一个用于更新 DataPivotHierarchy 对象上的数据的接口, 可用于 "DataPivotHierarchy (An interface for updating data on the DataPivotHierarchy object, for use in "dataPivotHierarchy.set({ ... })".

属性

field

返回与 DataPivotHierarchy 相关联的 PivotFields。Returns the PivotFields associated with the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

name

DataPivotHierarchy 的名称。Name of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

numberFormat

DataPivotHierarchy 的数字格式。Number format of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

position

DataPivotHierarchy 的位置。Position of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showAs

确定数据是否应显示为特定计算汇总。Determines whether the data should be shown as a specific summary calculation or not.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

summarizeBy

确定是否显示 DataPivotHierarchy 的所有项。Determines whether to show all items of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

属性详细信息

field

返回与 DataPivotHierarchy 相关联的 PivotFields。Returns the PivotFields associated with the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

field?: Excel.Interfaces.PivotFieldUpdateData;

属性值

name

DataPivotHierarchy 的名称。Name of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

name?: string;

属性值

string

numberFormat

DataPivotHierarchy 的数字格式。Number format of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

numberFormat?: string;

属性值

string

position

DataPivotHierarchy 的位置。Position of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

position?: number;

属性值

number

showAs

确定数据是否应显示为特定计算汇总。Determines whether the data should be shown as a specific summary calculation or not.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showAs?: Excel.ShowAsRule;

属性值

summarizeBy

确定是否显示 DataPivotHierarchy 的所有项。Determines whether to show all items of the DataPivotHierarchy.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

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

属性值

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