案例说明

       自动登录公司网站,抓取员工信息,汇总Excel表格

效果展示

案例实现

   /*
    版本: Creator 5.1.2
    功能: 员工信息提取机器人
    作者: By Hejing
    时间: 2020/8/19

    注意点: 需要运行python后台代码, 才能运行该Creator
            python代码Git地址, https://gitee.com/kobyant/zcdata.git

*/

// 0, 变量定义
dim userArray = []
dim salary = ""
dim jobin = ""
dim birthday = ""
dim address = ""
dim phone = ""
dim email = ""
dim sex = ""
dim name = ""
dim id = ""
dim iRet = ""
dim objExcelWorkBook = ""
dim users = [{"username":"366","password":"123456"},{"username":"367","password":"123456"},{"username":"368","password":"123456"},{"username":"369","password":"123456"}]
dim sRet = ""
dim hWeb = ""

//  1, 打开&绑定浏览器&打开网站
try 
 hWeb = WebBrowser.BindBrowser("chrome",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
iRet = WebBrowser.GoURL(hWeb,"http://127.0.0.1:8000/GZGL/",true,"",30000,{"bContinueOnError":false,"iDelayAfter":500,"iDelayBefore":200})
catch 
hWeb = WebBrowser.Create("chrome","http://127.0.0.1:8000/GZGL/",30000,{"bContinueOnError":false,"iDelayAfter":500,"iDelayBefore":200,"sBrowserPath":"","sStartArgs":""})
 end try
//  2, 点击目标登陆
Delay(3000)
#icon("@res:edkgf5sg-kibe-9q2p-3uaa-30nfdta2fnhs.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"SPAN","aaname":"XFindSalary"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:j75p5p84-omfn-i431-gt6a-r67t5on751nc.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","aaname":"登录 | Salary"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
For Each index,user In users
//  3, 填写账号,密码进行用户登陆
#icon("@res:oong7hot-tt25-ttuo-bbc6-klg3hcrgknh9.png")
Keyboard.InputText({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","name":"userid"}]},user["username"],true,20,10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"sKeyModifiers":[],"sSimulate":"message","bValidate":false})
#icon("@res:oong7hot-tt25-ttuo-bbc6-klg3hcrgknh9.png")
Keyboard.InputText({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","name":"password"}]},user["password"],true,20,10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"sKeyModifiers":[],"sSimulate":"message","bValidate":false})
#icon("@res:52ol0p67-7ghu-j73a-q9aj-nfq9kti38lja.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","id":"loginToMyAccount"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
//  4, 点击资料详情
#icon("@res:ej1bqroo-53ao-u0b6-9557-s835na4ki218.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","aaname":"                               我的资料                             *"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:e52li8ek-ubib-dan2-f249-se58oba20gt5.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","aaname":" 资料详情"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
//  5, 获取员工基本信息
#icon("@res:30ilqivj-6mrp-pre0-aogo-3po8dsht2qlh.png")
id = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputID"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:j0ur91cp-475c-rk24-llsf-6kcda6ml4p3g.png")
name = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputName"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:6d2m1boi-v3q4-5l3p-ifoh-1ctah71lrns7.png")
sex = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputsex"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:0n785pd1-i0qm-a5f2-e5fp-8s838uc0vebq.png")
email = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputEmail1"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:rf99dluk-p999-6ht8-orpf-dourrqnaft49.png")
phone = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputPhoneNum1"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:e54n1t9n-vroa-7dea-nggd-ipqrm465gdih.png")
address = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputAdress1"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:c1q8p05u-9dbg-s6s4-7iji-o09trha35rnq.png")
birthday = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"datepicker"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:67aku13o-1csa-37ch-arak-phsshcgo74io.png")
jobin = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputStaffJoinTime"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:tskaoe37-ju3j-hllt-rr5m-u0kol23hkvs9.png")
salary = UiElement.GetAttribute({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"inputSalary"}]},"placeholder",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
//  6, 写入到Excel中
try 
 objExcelWorkBook = Excel.BindBook("员工信息.xlsx")
catch 
 objExcelWorkBook = Excel.OpenExcel(@res"员工信息.xlsx",true)
end try
userArray = [id,name,sex,email,phone,address,birthday,jobin,salary]
Excel.WriteRow(objExcelWorkBook,"Sheet1","A1",["编号","姓名","性别","邮箱","手机","地址","生日","入职时间","薪资"],false)
Excel.WriteRow(objExcelWorkBook,"Sheet1","A"&(index+2),userArray,false)

//  7, 注销用户,重新登陆
#icon("@res:5bhcbkk8-smil-pqfi-0mcs-sj1v44j8pujv.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"SPAN","aaname":"* | *"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:i5vh217s-6et3-5qup-il3s-7g9v3go1c96e.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","aaname":" 注 销 "}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:mj53eog4-fkgo-juhe-l2lq-30r2p436aaip.png")
Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})

Next