RowAxisLayout 方法 (Excel)PivotTable.RowAxisLayout method (Excel)

此方法用于同时为所有现有的透视字段设置版式选项。This method is used for simultaneously setting layout options for all existing PivotFields.


表达式RowAxisLayout(RowLayout)expression.RowAxisLayout (RowLayout)

_表达式_一个代表**PivotTable** 对象的变量。expression A variable that represents a PivotTable object.


名称Name 必需/可选Required/Optional 数据类型Data type 说明Description
RowLayoutRowLayout 必需Required XlLayoutRowTypeXlLayoutRowType 指定版式行的类型。Specifies the type of layout row. 可以是 xlCompactRowxlTabularRowxlOutlineRowCan be xlCompactRow, xlTabularRow, or xlOutlineRow.


此方法是原子的, 因此, 如果无法在任何透视字段上设置布局选项, 则不会更改任何字段的布局选项, 也不会对数据透视表进行任何更改。This method is atomic so it makes sure that if layout options cannot be set on any PivotField, the layout options of none of the fields will change, and no change is made to the PivotTable.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.