import xlwings as xw
app = xw.App(visible = True, add_book = False)
for i in range(1,21):
workbook = app.books.add()
workbook.save(f'e:\example\01\员工信息表\分公司{i}.xlsx')
workbook.close()
app.quit()
报错内容
Traceback (most recent call last):
File "E:/python/Lib/site-packages/1.py", line 5, in
workbook.save(f'e:\example\01\员工信息表\分公司{i}.xlsx')
File "E:\python\Lib\site-packages\xlwings\main.py", line 874, in save
self.impl.save(path)
File "E:\python\Lib\site-packages\xlwings_xlwindows.py", line 582, in save
self.xl.SaveAs(os.path.realpath(path), FileFormat=file_format)
File "E:\python\Lib\site-packages\xlwings_xlwindows.py", line 70, in call
v = self.__method(*args, **kwargs)
File "C:\Users\22131\AppData\Local\Temp\gen_py\3.7\00020813-0000-0000-C000-000000000046x0x1x9.py", line 46796, in SaveAs
, Local, WorkIdentity)
pywintypes.com_error: (-2147352567, '发生意外。', (0, 'Microsoft Excel', 'Microsoft Excel 不能访问文件“e:\example\01\员工信息表\CF35C750”。