Excel.Interfaces.DataPivotHierarchyLoadOptions interface

表示 Excel DataPivotHierarchy。Represents the Excel DataPivotHierarchy.

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

属性

$all
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 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

field

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

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

field?: Excel.Interfaces.PivotFieldLoadOptions;

属性值

id

DataPivotHierarchy ID。Id of the DataPivotHierarchy.

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

id?: boolean;

属性值

boolean

name

DataPivotHierarchy 的名称。Name of the DataPivotHierarchy.

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

name?: boolean;

属性值

boolean

numberFormat

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

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

numberFormat?: boolean;

属性值

boolean

position

DataPivotHierarchy 的位置。Position of the DataPivotHierarchy.

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

position?: boolean;

属性值

boolean

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?: boolean;

属性值

boolean

summarizeBy

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

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

summarizeBy?: boolean;

属性值

boolean