我刚好碰到过类似的Mac上xlwings操作Excel大纲的问题，给你分享个可行的解决方案：

首先得明确，Mac版xlwings和Windows版的底层接口不一样——Windows用的是COM对象，而Mac用的是AppleScript桥接，所以之前针对Windows的sheet.api.Outline方法在Mac上肯定会报错。要在Mac上实现折叠所有已有大纲到0级，得用xlwings提供的appscript接口来调用Excel的AppleScript命令。

具体实现代码 #

import xlwings as xw

# 打开工作簿并指定目标工作表
wb = xw.Book("你的文件路径.xlsx")
sheet = wb.sheets["目标工作表名称"]

# 折叠所有行分组大纲至0级
sheet.appscript.outline_row_levels(1).collapse()
# 折叠所有列分组大纲至0级
sheet.appscript.outline_column_levels(1).collapse()

代码解释 #

• sheet.appscript：这是xlwings在Mac上访问Excel AppleScript接口的入口，通过它能调用Mac Excel原生支持的AppleScript命令
• outline_row_levels(1).collapse()：这里的1代表所有1级及以上的行分组大纲，调用collapse()会把这些层级全部折叠，最终回到0级状态（只显示最外层内容，分组区域保持非隐藏）
• 同理outline_column_levels(1).collapse()处理列的分组大纲

验证折叠效果 #

如果需要确认是否成功折叠到0级，可以用以下代码检查：

# 检查行大纲当前显示层级（成功折叠后返回0）
print(sheet.appscript.outline_row_show_level())
# 检查列大纲当前显示层级（成功折叠后返回0）
print(sheet.appscript.outline_column_show_level())

原问题背景 #

I'm using xlwings with python to copy one excel sheet to another. As part of the copying, however, I'd like to collapse all the grouped columns.

This is different than hiding the relevant columns and rows; I want them to be non-hidden, but just have the outlines collapsed to level 0!

And to be clear, I also don't want to create new outlines; I just want all the existing ones to be collapsed.

Is there a simple command to do that? Cannot find it via google. (if the answer is to group specific ranges - the answer also would need to list how to find the ranges that are available for grouping!).

Edited to add: The solution must work on MacOS. The answer proposed by @grismar below fails on a Mac:

(Pdb) sheet.api.Outline  
*** AttributeError: Unknown property, element or command: 'Outline' 

备注：内容来源于stack exchange，提问作者YGA