导入Excel素材

适用场景：

如果需要RPA完成某些表单填写的场景，可以尝试在流程中加入【导入Excel素材】。

场景举例：

1. 访问：https://www.facebook.com/login

2. 在登录界面输入账号与密码

使用说明：

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

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

[{"type":"useExcel","config":{"path":"C:\\Users\\admin\\Desktop\\rpa.xlsx","isSkip":"0","variableList":["phone","password"],"variable":"","remark":""}},{"type":"newPage","config":{}},{"type":"gotoUrl","config":{"url":"https://www.facebook.com/login","timeout":30000,"remark":""}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":517,"timeoutMin":7111,"timeoutMax":8145,"remark":""}},{"type":"inputContent","config":{"selector":"#email","selectorType":"selector","element":"","serial":1,"intervals":300,"content":"${phone}","isRandom":"0","randomContent":"${email}","remark":"输入登录手机号"}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":400,"timeoutMin":1421,"timeoutMax":2222,"remark":""}},{"type":"inputContent","config":{"selector":"#pass","selectorType":"selector","element":"","serial":1,"intervals":300,"content":"${password}","isRandom":"0","randomContent":"${password}","remark":"输入登录密码"}},{"type":"click","config":{"selector":"#loginbutton","selectorType":"selector","element":"","serial":1,"button":"left","type":"click","remark":"","serialType":"fixedValue","serialMin":1,"serialMax":10}},{"type":"waitTime","config":{"timeoutType":"randomInterval","timeout":400,"timeoutMin":3421,"timeoutMax":4222,"remark":""}}]

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

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

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