新手上路,Python编程使用xlwings模块,代码如下:
import xlwings as xw
app=xw.App(visible=True,add_book=False)
workbook=app.books.add()
运行后报错如下:
Traceback (most recent call last):
File "D:/pythonProject/XLWINGS.py", line 2, in
app=xw.App(visible=True,add_book=False)
File "D:\pythonProject\venv\lib\site-packages\xlwings\main.py", line 279, in init
self.impl = engines.active.apps.add(
File "D:\pythonProject\venv\lib\site-packages\xlwings\main.py", line 188, in add
return App(impl=self.impl.add(**kwargs))
File "D:\pythonProject\venv\lib\site-packages\xlwings_xlwindows.py", line 492, in add
return App(spec=spec, add_book=add_book, xl=xl, visible=visible)
File "D:\pythonProject\venv\lib\site-packages\xlwings_xlwindows.py", line 516, in init
self.xl = COMRetryObjectWrapper(DispatchEx("Excel.Application"))
File "D:\pythonProject\venv\lib\site-packages\win32com\client_init.py", line 113, in DispatchEx
dispatch = pythoncom.CoCreateInstanceEx(clsid, None, clsctx, serverInfo, (pythoncom.IID_IDispatch,))[0]
pywintypes.com_error: (-2147418113, '灾难性故障', None, None)
请教各位,有可能是什么原因呢?(win7系统,3.8版本python,pycharm装的第三方库)
已解决,因为之前用excelVBA 加装了个VBA宏病毒查杀。VBA宏病毒查杀的功能就是禁止excel自动操作并向固定地址发送信息。XLWINGS功能也是对表格进行自动化操作,估计将其认为是病毒了。宏病毒软件 删除后功能正常