怎么让表格Sheet1的内容剪切写入到Sheet2里
回答
收藏

怎么让表格Sheet1的内容剪切写入到Sheet2里

热归女方
2023-08-07 17:21·浏览量:359
热归女方
发布于 2023-08-07 17:15更新于 2023-08-07 17:21359浏览

我想写一个网站新闻自动发布的应用;怎么将每一次发布后的内容,从Sheet1剪切写入到Sheet2里?

Sheet1被剪切后剩下的内容一直保持在第2行?



应该是先 拷贝excel内容,再粘贴到excel中,不知道用的对不对,应该不对

提示错误信息

无法将 "Silybin A | MedChemExpress (MCE)" 转成小数
Traceback (most recent call last):
  File "D:\ShadowBot\shadowbot-5.12.31\python\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "D:\ShadowBot\shadowbot-5.12.31\python\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "D:\ShadowBot\shadowbot-5.12.31\python\lib\site-packages\xbot_interpreter.py", line 87, in <module>
    main()
  File "D:\ShadowBot\shadowbot-5.12.31\python\lib\site-packages\xbot_interpreter.py", line 47, in main
    try:
  File "C:\Users\Administrator\AppData\Local\ShadowBot\users\ad5df1b4-a295-45d2-86df-6047b22b98b2\apps\41113b73-93fb-4bd6-a9d4-7ed66aa601cc\xbot_robot\process2.py", line 44, in main
    xbot_visual.excel.copy_range(workbook=excel_instance, copy_way="row", range=None, cell_row_num=None, cell_column_name=None, area_begin_row_num=None, area_begin_column_name=None, area_end_row_num=None, area_end_column_name=None, row_row_num=loop_excel, column_column_name=None, sheet_name="", _block=("子流程2", 18, "拷贝Excel内容"))
  File "<string>", line 89, in wrapper
  File "<string>", line 84, in wrapper
  File "<string>", line 874, in copy_range
  File "<string>", line 218, in get_multi_row_num
ValueError: could not convert string to float: 'Silybin A | MedChemExpress (MCE)'

 


还有一个问题,发布完了之后一次性剪切写入到sheet2,怎么写流程


图是应用流程

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