Excel.Interfaces.PivotLayoutUpdateData interface

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

属性

autoFormat

指定在刷新或移动域时是否自动设置格式设置的格式Specifies whether formatting will be automatically formatted when it’s refreshed or when fields are moved

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

enableFieldList

指定字段列表是否可以显示在 UI 中。Specifies whether the field list can be shown in the UI.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

layoutType

此属性指示数据透视表上的所有字段的 PivotLayoutType。This property indicates the PivotLayoutType of all fields on the PivotTable. 如果字段状态不同,则为 null。If fields have different states, this will be null.

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

preserveFormatting

指定当通过透视、排序或更改页字段项等操作刷新或重新计算报表时, 是否保留格式设置。Specifies whether formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

showColumnGrandTotals

指定数据透视表报表是否显示列总计。Specifies whether the PivotTable report shows grand totals for columns.

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

showRowGrandTotals

指定数据透视表报表是否显示行总计。Specifies whether the PivotTable report shows grand totals for rows.

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

subtotalLocation

此属性指示数据透视表上的所有字段的 SubtotalLocationType。This property indicates the SubtotalLocationType of all fields on the PivotTable. 如果字段状态不同,则为 null。If fields have different states, this will be null.

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

属性详细信息

autoFormat

指定在刷新或移动域时是否自动设置格式设置的格式Specifies whether formatting will be automatically formatted when it’s refreshed or when fields are moved

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

autoFormat?: boolean;

属性值

boolean

enableFieldList

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

指定字段列表是否可以显示在 UI 中。Specifies whether the field list can be shown in the UI.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

enableFieldList?: boolean;

属性值

boolean

layoutType

此属性指示数据透视表上的所有字段的 PivotLayoutType。This property indicates the PivotLayoutType of all fields on the PivotTable. 如果字段状态不同,则为 null。If fields have different states, this will be null.

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

layoutType?: Excel.PivotLayoutType | "Compact" | "Tabular" | "Outline";

属性值

Excel.PivotLayoutType | "Compact" | "Tabular" | "Outline"

preserveFormatting

指定当通过透视、排序或更改页字段项等操作刷新或重新计算报表时, 是否保留格式设置。Specifies whether formatting is preserved when the report is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

preserveFormatting?: boolean;

属性值

boolean

showColumnGrandTotals

指定数据透视表报表是否显示列总计。Specifies whether the PivotTable report shows grand totals for columns.

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

showColumnGrandTotals?: boolean;

属性值

boolean

showRowGrandTotals

指定数据透视表报表是否显示行总计。Specifies whether the PivotTable report shows grand totals for rows.

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

showRowGrandTotals?: boolean;

属性值

boolean

subtotalLocation

此属性指示数据透视表上的所有字段的 SubtotalLocationType。This property indicates the SubtotalLocationType of all fields on the PivotTable. 如果字段状态不同,则为 null。If fields have different states, this will be null.

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

subtotalLocation?: Excel.SubtotalLocationType | "AtTop" | "AtBottom" | "Off";

属性值

Excel.SubtotalLocationType | "AtTop" | "AtBottom" | "Off"