导入Excel素材

 

场景举例：

 

使用说明：

第1步：如图所示：新建一个Excel文档，表头填写两个变量，email、password，分别用来存放邮箱与密码。填写完毕之后，保存该Excel文档。

 

第2步：复制下面的流程JSON，将其导入到RPA流程。（注意：网站代码可能会有变化，部分选择器可能会失效。该案例仅供参考）

[{"type":"useExcel","config":{"path":"C:\\Users\\snake\\Desktop\\RPA test.xlsx","variableList":["email","password"],"remark":""}},{"type":"newPage","config":{}},{"type":"gotoUrl","config":{"url":"https://www.mercari.com/login/","timeout":30000,"remark":""}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":517,"timeoutMin":7111,"timeoutMax":8145,"remark":""}},{"type":"inputContent","config":{"selector":"[name=\"email\"]","selectorType":"selector","element":"","serial":1,"intervals":300,"content":"${email}","isRandom":"0","randomContent":"${email}","remark":"输入登录邮箱"}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":400,"timeoutMin":1421,"timeoutMax":2222,"remark":""}},{"type":"inputContent","config":{"selector":"[name=\"password\"]","selectorType":"selector","element":"","serial":1,"intervals":300,"content":"${password}","isRandom":"0","randomContent":"${password}","remark":"输入登录密码"}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":400,"timeoutMin":3421,"timeoutMax":4222,"remark":""}}]

 

第3步：点击【导入】，将复制的JSON代码粘贴至此。

 

第4步：修改【导入Excel素材】，将文件路径改为Excel的文件路径。

 

第5步：保存该流程，勾选3个环境，执行该RPA流程