Excel.Interfaces.PivotFieldUpdateData interface

用于更新透视字段对象上的数据的接口, 可用于 "透视字段"。 set (An interface for updating data on the PivotField object, for use in "pivotField.set({ ... })".

属性

name

PivotField 的名称。Name of the PivotField.

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

showAllItems

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

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

subtotals

PivotField 小计。Subtotals of the PivotField.

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

属性详细信息

name

PivotField 的名称。Name of the PivotField.

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

name?: string;

属性值

string

showAllItems

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

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

showAllItems?: boolean;

属性值

boolean

subtotals

PivotField 小计。Subtotals of the PivotField.

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

subtotals?: Excel.Subtotals;

属性值