Excel.Interfaces.DataPivotHierarchyData interface

描述通过调用 "dataPivotHierarchy ()" 返回的数据的接口。An interface describing the data returned by calling "dataPivotHierarchy.toJSON()".

属性

field

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

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

id

DataPivotHierarchy ID。Id of 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.PivotFieldData;

属性值

id

DataPivotHierarchy ID。Id of the DataPivotHierarchy.

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

id?: string;

属性值

string

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"