Excel.Interfaces.PivotLayoutData interface

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

属性

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"