我想写一个网站新闻自动发布的应用;怎么将每一次发布后的内容,从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,怎么写流程
图是应用流程

