python中使用xlwings中save函数用不了，报错如下

C:\Users\admin\anaconda3\python.exe C:/Users/admin/PycharmProjects/pythonProject2/保存工作簿.py
Traceback (most recent call last):
File "C:\Users\admin\PycharmProjects\pythonProject2\保存工作簿.py", line 6, in
workbook.save('d:\example.xlsx')
File "C:\Users\admin\anaconda3\lib\site-packages\xlwings\main.py", line 875, in save
self.impl.save(path)
File "C:\Users\admin\anaconda3\lib\site-packages\xlwings_xlwindows.py", line 582, in save
self.xl.SaveAs(os.path.realpath(path), FileFormat=file_format)
File "C:\Users\admin\anaconda3\lib\site-packages\xlwings_xlwindows.py", line 70, in call
v = self.__method(*args, **kwargs)
File "C:\Users\admin\AppData\Local\Temp\gen_py\3.9\00020813-0000-0000-C000-000000000046x0x1x9.py", line 46807, in SaveAs
return self.oleobj.InvokeTypes(3174, LCID, 1, (24, 0), ((12, 17), (12, 17), (12, 17), (12, 17), (12, 17), (12, 17), (3, 49), (12, 17), (12, 17), (12, 17), (12, 17), (12, 17), (12, 17)),Filename
pywintypes.com_error: (-2147352573, '找不到成员。', None, None)

Process finished with exit code 1

用下面代码试试：

import xlwings
app = xlwings.App(visible=True, add_book=False)
w = app.books.add()
w.save('aa.xlsx')

在python反斜杠会作为转义符，路径不正确读取不到文件，路径要写成：r'D:\example.xlsx'或：‘'D:/example.xlsx"
如有帮助，请采纳。

源代码如上

可能是装了wps和excel两种，修改wps设置，使之不关联excel

同时安装了offices和wps，最直接的方法时把wps卸载了。或者要保留wps的话，就菜单找到wps--配置--高级--把兼容取消掉