UiBot初级实践：操作Excel与网页登录示例

Dim user = ""
Dim objExcelWorkBook = ""
Dim iRet = ""
Dim hWeb = ""
Dim lines = ""
Dim arrayL = ""
Dim danyuan
Dim objRet = ""
Dim arrRet = ""


user = Dialog.InputBox("","请输入邮箱账号","",False)
psw = Dialog.InputBox("","请输入邮箱密码","",False)
objExcelWorkBook = Excel.OpenExcel("C:\\Users\\Administrator\\Desktop\\UiBot初级实践题.xls",true)
Excel.WriteColumn(objExcelWorkBook,"Sheet1","C2",['RPA实施工程师（初级）实践题','RPA实施工程师（初级）实践题','RPA实施工程师（初级）实践题'],False)
Excel.Save(objExcelWorkBook)
Excel.CloseExcel(objExcelWorkBook,True)




hWeb = WebBrowser.Create("ie","https://mail.163.com/",30000,{"bContinueOnError":False,"iDelayAfter":300,"iDelayBefore":200,"sBrowserPath":"C:\\Users\\Administrator\\AppData\\Roaming\\360se6\\Application\\360se.exe","sStartArgs":""})
#icon("@res:4fnr5b29-3q8p-1hq8-rt0b-gcuiovctigc3.png")
UiElement.SetValue({"wnd":[{"app":"360se","cls":"360se6_Frame","title":"163网易免费邮--中文邮箱第一品牌 - 360安全浏览器 12.2"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window","aaname":"163网易免费邮--中文邮箱第一品牌"}],"ctrl":[{"role":"ROLE_SYSTEM_DOCUMENT","name":"163网易免费邮--中文邮箱第一品牌"},{"role":"ROLE_SYSTEM_DOCUMENT","name":"URS组件"},{"role":"ROLE_SYSTEM_TEXT","name":"邮箱帐号或手机号码"}]},user,{"bContinueOnError":False,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:idm8mar6-4k3d-si23-d2g0-fk3oj90k5mr2.png")
UiElement.SetValue({"wnd":[{"app":"360se","cls":"360se6_Frame","title":"163网易免费邮--中文邮箱第一品牌 - 360安全浏览器 12.2"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window","aaname":"163网易免费邮--中文邮箱第一品牌"}],"ctrl":[{"role":"ROLE_SYSTEM_DOCUMENT","name":"163网易免费邮--中文邮箱第一品牌"},{"role":"ROLE_SYSTEM_DOCUMENT","name":"URS组件"},{"role":"ROLE_SYSTEM_TEXT","name":"输入密码"}]},psw,{"bContinueOnError":False,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:pcqf9jaj-lkb6-poar-8qfo-4jf9jaj8uifm.png")
Mouse.Action({"wnd":[{"app":"360se","cls":"360se6_Frame","title":"163网易免费邮--中文邮箱第一品牌 - 360安全浏览器 12.2"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"ctrl":[{"role":"ROLE_SYSTEM_DOCUMENT","name":"163网易免费邮--中文邮箱第一品牌"},{"role":"ROLE_SYSTEM_DOCUMENT","name":"URS组件"},{"role":"ROLE_SYSTEM_LINK","name":"登??录"}]},"left","click",10000,{"bContinueOnError":False,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})