RPA 设计器 8.0 使用 excel 插入行 控件报错
程序代码：
def flow4(self):
lv_value=[[‘2019/01/11’,‘aaaa’],[‘2019/01/11’,‘bbbb’]]
lv_filename=r’F:\global\rpa\ 核对结果差异表.xlsx’
#插入行
self.__logger.debug(’ “StepNodeTag:11154401809”,Note:’)
iexcel.ins_row(path=lv_filename,sheet=1,cell=‘A2’,data=lv_value)
整个日志如下：
begin
begin
Main.py- “StepNodeTag:11154401809”,Note:
Traceback (most recent call last):
File “E:\isearch\testProject\codes\Main.py”, line 176, in
pro.flow4()
File “E:\isearch\testProject\codes\Main.py”, line 157, in flow4
iexcel.ins_row(path=lv_filename,sheet=1,cell=‘A2’,data=lv_value)
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\lib\ubpa\iexcel.py”, line 165, in ins_row
raise e
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\lib\ubpa\iexcel.py”, line 159, in ins_row
wb = xw.Book(path)
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\lib\site-packages\xlwings\main.py”, line 479, in init
app = App(add_book=False)
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\lib\site-packages\xlwings\main.py”, line 204, in init
self.impl = xlplatform.App(spec=spec, add_book=add_book)
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\lib\site-packages\xlwings_xlwindows.py”, line 288, in init
self.xl = COMRetryObjectWrapper(DispatchEx(‘Excel.Application’))
File “C:\iS-RPA8.0\plugin\Com.Isearch.Func.Python\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: (-2147221005, ‘无效的类字符串’, None, None)
运行结束
网上查了一下，你这个要么不是微软 excel（isrpa 不支持 wps），要么 excel 版本有些问题，是 pywintypes 调用 com 组件时找不到的意思