xlwings 调用电子表格，提示 pywintypes.com_error: (-2147221005, ‘无效的类字符串‘, None, None)错误的解决

rollingData

于 2020-08-31 17:53:03 发布

阅读量6.1k

点赞数 2

分类专栏：心得文章标签： python

本文链接：https://blog.csdn.net/zqndata/article/details/108326059

版权

将操作系统迁移到WTG后，使用xlwings调用电子表格出现`pywintypes.com_error: (-2147221005, ‘无效的类字符串‘, None, None)`错误。问题在于系统中安装的是WPS而非Excel。通过查找注册表，发现WPS电子表格对应的类名为'KET.Application'。修改xlwings的_xlwindows.py文件，将'Excel.Application'替换为'KET.Application'，成功解决调用问题。" 107682243,8556824,小程序实现滑动金刚区与进度条,"['小程序开发', '前端框架', 'UI设计', 'css3动画', '交互设计']

摘要由CSDN通过智能技术生成

问题：xlwings一直运行正常，操作系统迁移到wtg上，xlwings调用电子表格操作，出现以下提示：

Building prefix dict from the default dictionary ...
Loading model from cache D:\Personal\TEMP\jieba.cache
Loading model cost 1.349 seconds.
Prefix dict has been built successfully.
Traceback (most recent call last):
File "D:\Crawler\focus.py", line 103, in <module>
recognize(targetWord,includeKeysWord)
File "D:\Crawler\focus.py", line 96, in recognize
output(x, y)
File "D:\Crawler\focus.py", line 58, in output
app=xlw.App(visible=False,add_book=False)
File "C:\Language\Python\Python3\lib\site-packages\xlwings\main.py", line 210, in __init__
self.impl = xlplatform.App(spec=spec, add_book=add_book)
File "C:\Language\Python\Python3\lib\site-packages\xlwings\_xlwindows.py", line 299, in __init__