筛选功能只要填Sheet页名称就报错,Excel文件里有这个名称的sheet页的。调用激活Sheet页,填上同样的名称是可以正常执行
报错信息:
(-2147352567, '发生意外。', (0, None, None, None, 0, -2147352565), None)
Traceback (most recent call last):
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.12.23\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.12.23\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.12.23\python\lib\site-packages\xbot_interpreter.py", line 87, in <module>
main()
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.12.23\python\lib\site-packages\xbot_interpreter.py", line 47, in main
try:
File "C:\Users\Lenovo\AppData\Local\ShadowBot\users\101928455584595969\apps\d2c256de-9c73-457f-acd0-e89c2eddea59\xbot_robot\main.py", line 26, in main
], _block=("main", 7, "筛选"))
File "<string>", line 89, in wrapper
File "<string>", line 84, in wrapper
File "<string>", line 82, in run
File "C:\Users\Lenovo\AppData\Local\ShadowBot\users\101928455584595969\apps\d2c256de-9c73-457f-acd0-e89c2eddea59\xbot_extensions\activity_excel_v2\filter.py", line 39, in main
}, _block=("C_01_筛选", 1, "调用模块"))
File "<string>", line 89, in wrapper
File "<string>", line 84, in wrapper
File "<string>", line 37, in invoke_module
File "C:\Users\Lenovo\AppData\Local\ShadowBot\users\101928455584595969\apps\d2c256de-9c73-457f-acd0-e89c2eddea59\xbot_extensions\activity_excel_v2\invoke_modules.py", line 275, in excel_autofilter
sht = validate_sheet(excel_instance, sheet_name, mode=2)
File "C:\Users\Lenovo\AppData\Local\ShadowBot\users\101928455584595969\apps\d2c256de-9c73-457f-acd0-e89c2eddea59\xbot_extensions\activity_excel_v2\validators.py", line 105, in validate_sheet
if sheet_name not in get_sheet_names(excel_instance):
File "C:\Users\Lenovo\AppData\Local\ShadowBot\users\101928455584595969\apps\d2c256de-9c73-457f-acd0-e89c2eddea59\xbot_extensions\activity_excel_v2\validators.py", line 70, in get_sheet_names
name_list.append(excel_instance.workbook.Sheets[i].name)
File "C:\Users\Lenovo\AppData\Local\Temp\gen_py\3.7\00020813-0000-0000-C000-000000000046x0x1x6.py", line 30653, in __getitem__
return self._get_good_object_(self._oleobj_.Invoke(*(170, LCID, 2, 1, key)), "Item", None)
pywintypes.com_error: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147352565), None)