数据排序,WPS正常,OFFICE报错
回答
收藏

数据排序,WPS正常,OFFICE报错

h
haizeizei
2024-02-19 18:09·浏览量:180
h
haizeizei
发布于 2024-02-19 18:09180浏览

请问为什么在给EXCEL表格中的数据进行排序时,驱动选择WPS正常,但是选择OFFICE报错

<unknown>.Sort

Traceback (most recent call last):

 File "G:\Program Files (x86)\ShadowBot\shadowbot-5.15.47\python\lib\runpy.py", line 193, in _run_module_as_main

   "__main__", mod_spec)

 File "G:\Program Files (x86)\ShadowBot\shadowbot-5.15.47\python\lib\runpy.py", line 85, in _run_code

   exec(code, run_globals)

 File "G:\Program Files (x86)\ShadowBot\shadowbot-5.15.47\python\lib\site-packages\xbot_interpreter.py", line 113, in <module>

   main()

 File "G:\Program Files (x86)\ShadowBot\shadowbot-5.15.47\python\lib\site-packages\xbot_interpreter.py", line 57, in main

   try:

 File "C:\Users\Administrator\AppData\Local\ShadowBot\users\654589573236346882\apps\be5198b0-f6ad-4b4f-b70d-32aeb5427267\xbot_robot\main.py", line 10, in main

   xbot_visual.excel.custom_sort(workbook=excel_instance2, sort_way="ascending", sort_column="1", is_expand_selected_area=True, is_firstline_notsort=True, sort_setting=None, range_type="used_range", range=None, start_row=None, start_column=None, end_row=None, end_column=None, sheet_name="", _block=("main", 2, "Excel排序"))

 File "<string>", line 92, in wrapper

 File "<string>", line 87, in wrapper

 File "<string>", line 1467, in custom_sort

 File "<string>", line 691, in asc_or_desc_sort

 File "G:\Program Files (x86)\ShadowBot\shadowbot-5.15.47\python\lib\site-packages\win32com\client\dynamic.py", line 527, in __getattr__

   raise AttributeError("%s.%s" % (self._username_, attr))

AttributeError: <unknown>.Sort


收藏
全部回答1
最新
发布回答
回答