java文件无法保存_无法在XLWings上保存文件

[使用XLWINGS包装]

我正在尝试打开excel电子表格(现有)，将数据写入指定的单元格，然后使用workbook.save()函数将文件保存为新文件名(不要覆盖)

现在我现在有：

app = xw.App(visible = False)

wbMain = wx.Book('Example.xlsm') #Open premade excel file

sheetMain = wbMain.sheets['Example']

sheetMain.range('A1').value = 'Test' #Modify value of cell A1

wbMain.save('NewFileName.xlsm') #Save to new filename

wbMain.close() #Close current excel sheet

app.kill() #Kill program (may not work)

(抱歉我的格式化如果关闭)

这是我的追溯：

Traceback (most recent call last):

File "C:\Users\USER\Desktop\test_proj\main.py", line 34, in

wbMain.save(NewFileName.xlsm)

----

File "C:\Users\USER\AppData\Local\Programs\Python\Python35\lib\site-

packages\xlwings\main.py", line 688, in save

return self.impl.save(path)

---

File "C:\Users\USER\AppData\Local\Programs\Python\Python35\lib\site-

packages\xlwings\_xlwindows.py", line 472, in save

self.xl.SaveAs(os.path.realpath(path))

----

File "C:\Users\USER\AppData\Local\Programs\Python\Python35\lib\site-

packages\xlwings\_xlwindows.py", line 63, in __call__

v = self.__method(*args, **kwargs)

---

File "", line 7, in SaveAs

pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft

Excel', 'SaveAs method of Workbook class failed', 'xlmain11.chm', 0,

-2146827284), None)

我试过看XLWings文档和各种其他stackoverflow线程，但似乎没有提供一个有效的解决方案 . 以前有人有同样的问题吗？