xlwings 表格排序报错

Question

我尝试用xlwings对表格进行排序，但是一直报错，请问如何解决？
代码：

app = xw.App(add_book=True, visible=True)

wb2_path = 'F:\桌面\M.xlsx'
wb2 = app.books.open(wb2_path)
sht2 = wb2.sheets[0]
sht2.range('D11627:N11700').api.Sort(Key1=sht2.range('D11627').api, Order1=1, Orientation=1)

报错：
Traceback (most recent call last):
File "E:*********\python\test.py", line 604, in
sht2.range('D11627:N11700').api.Sort(Key1=sht2.range('D11627').api, Order1=1, Orientation=1)
File "C:\Users\DELL\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\xlwings_xlwindows.py", line 72, in call
v = self.__method(*args, **kwargs)

File "C:\Users\DELL\AppData\Local\Temp\gen_py\3.9\00020813-0000-0000-C000-000000000046x0x1x9.py", line 33924, in Sort
return self.ApplyTypes(3288, 1, (12, 0), ((12, 17), (3, 49), (12, 17), (12, 17), (3, 49), (12, 17), (3, 49), (3, 49), (12, 17), (12, 17), (3, 49), (3, 49), (3, 49), (3, 49), (3, 49), (12, 17)), 'Sort', None,Key1
File "C:\Users\DELL\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\win32com\client_init_.py", line 572, in ApplyTypes
self.oleobj.InvokeTypes(dispid, 0, wFlags, retType, argTypes, *args),
pywintypes.com_error: (-2147352573, '找不到成员。', None, None)

Process finished with exit code 1

Answer 1

import xlwings as xw
wb2_path = 'F:\桌面\M.xlsx'
wb2 = xw.Books(wb2_path)
sht2 = wb2.sheets[0]    #最好以  sht2 = wb2.sheets["Sheet2"] 的格式
#Order1=1/2 (升序/降序), Orientation=1/2 (按行排/按列排）,Header=1/2/0(有标题/无标题/系统识别）
sht2.range('D11627:N11700').api.Sort(Key1=sht2.range('D11627').api, Order1=1, Orientation=1, Header=1)

#详细可以查看  链接1：https://blog.csdn.net/xwzxlsl/article/details/131879461?spm=1001.2014.3001.5501，  
#  链接2：https://blog.csdn.net/xwzxlsl/article/details/131867369?spm=1001.2014.3001.5501