excel Python出错

k10s72fa 于 2023-02-14 发布在 Python

关注(0)|答案(1)|浏览(139)

下面的代码抛出我的错误。这是工作正常早些时候。不知道现在发生了什么事。任何帮助？

import win32com.client as win32

excel = win32.gencache.EnsureDispatch('Excel.Application')

wb=excel.Workbooks.Open('C:\Technical\AutomationScripts\Model_Variable_Path.xlsx')

excel.Visible = True

Trace Error 
File "C:\Technical\AutomationScripts\Testscript.py", line 2, in <module>
excel = win32.gencache.EnsureDispatch('Excel.Application')

File "C:\Program Files\Python39\lib\site-packages\win32com\client\gencache.py", line 625, in EnsureDispatch

mod = EnsureModule(tla[0], tla[1], tla[3], tla[4], bForDemand=bForDemand)

AttributeError: module 'win32com.gen_py.00020813-0000-0000-C000-000000000046x0x1x9' has no attribute 'MinorVersion'

excel

来源：https://stackoverflow.com/questions/75401867/python-erroring