本人电脑安装的是Microsoft Office Excel 2007 ,使用以下代码指定文件路径创建多个Excel表
# 第一章 使用Python操作Excel的初步认识
import xlwings as xw
# 使用python在指定的文件夹中快速创建多个excel表
filePath="D:\wd\PythonExcelFile"
def one():
# 创建操作的对象
# 程序可见,新建工作簿
app=xw.App(visible=True,add_book=False)
app.display_alerts = False # 警告关闭
app.screen_updating = False # 屏幕更新关闭,可以减少卡顿
# 开启循环创建
for i in range(1,21):
# 获得添加的权限
workBook=app.books.add()
# 指定文件的全文件名
workBook.save(f"D:\\wd\\PythonExcelFile\\table{i}.xlsx")
# 创建一个即关闭
workBook.close()
# 执行结束后,关闭对象,释放内存
app.quit()
if __name__ == "__main__":
one()
运行时,出现以下报错
C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\python.exe D:/wd/pythonfile/2022PythonExcel/ExcelTest1.py
Traceback (most recent call last):
File "D:/wd/pythonfile/2022PythonExcel/ExcelTest1.py", line 24, in <module>
one()
File "D:/wd/pythonfile/2022PythonExcel/ExcelTest1.py", line 9, in one
app=xw.App(visible=True,add_book=False)
File "C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\lib\site-packages\xlwings\main.py", line 295, in __init__
spec=spec, add_book=add_book, visible=visible
File "C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\lib\site-packages\xlwings\main.py", line 203, in add
return App(impl=self.impl.add(**kwargs))
File "C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\lib\site-packages\xlwings\_xlwindows.py", line 497, in add
return App(spec=spec, add_book=add_book, xl=xl, visible=visible)
File "C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\lib\site-packages\xlwings\_xlwindows.py", line 521, in __init__
self._xl = COMRetryObjectWrapper(DispatchEx("Excel.Application"))
File "C:\Users\Administrator.WIN7-1912041238\AppData\Local\Programs\Python\Python37\lib\site-packages\win32com\client\__init__.py", line 146, in DispatchEx
clsid, None, clsctx, serverInfo, (pythoncom.IID_IDispatch,)
pywintypes.com_error: (-2147221005, '无效的类字符串', None, None)
Process finished with exit code 1
通过查找了很多解决的办法,发现都是使用WPS的,而我原本就是Microsoft Office Excel 2007,出现这个问题该怎么解决,各位大佬是否有解决办法???