Excel.Interfaces.PivotFieldData interface

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

属性

id

PivotField 的 ID。Id of the PivotField.

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

items

返回与 PivotField 相关联的 PivotFields。Returns the PivotFields associated with 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 ]

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 ]

属性详细信息

id

PivotField 的 ID。Id of the PivotField.

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

id?: string;

属性值

string

items

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

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

items?: Excel.Interfaces.PivotItemData[];

属性值

Excel.Interfaces.PivotItemData[]

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;

属性值