uibot 获取excel大范围数据然后对应的填入各个web框中

• uibot 获取excel大范围数据然后对应的填入各个web框中

• Dim bRet = ""
  Dim objRet = ""
  Dim arrSet = ""
  Dim arrayRet = ""
  Dim objExcelWorkBook = ""
  objExcelWorkBook = Excel.OpenExcel('''C:\Users\Asus\Documents\Tencent Files\1778296894\FileRecv\合并3.xlsx''',False,"WPS","","")
  objRet = Excel.ReadCell(objExcelWorkBook,"sheet1","A20151:A30000")//A16322:A30000、、A19659
  //A18362
  //arrayRet = Excel.ReadRange(objExcelWorkBook,"Sheet1","D2:D96")
  //arrayRet = Excel.ReadColumn(objExcelWorkBook,"Sheet1","D9")
  
  Excel.CloseExcel(objExcelWorkBook,True)
  arrSet = Set.ToArray(objRet)
  
  For Each id_no In arrSet
      If id_no = ""
          Continue
      Else
          
          #icon("@res:piuqo5gi-1vu1-moc0-9k5o-3m07us5kf22k.png")
          Keyboard.InputText({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"INPUT","id":"c4_wlno"}]},id_no,True,20,10000,{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":500,"bSetForeground":True,"sSimulate":"message","bValidate":True,"bClickBeforeInput":True})
          #icon("@res:b2dlcs8v-m66h-p9tf-s6ca-mm3609mj6o80.png")
          UiElement.SetSelect({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"SELECT"}]},"所有","text",{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":200})
          #icon("@res:jjjp4ipl-lci5-ujri-risl-0bopeeh30gk5.png")
          Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","parentid":"filterMoreDiv"}]},"left","click",10000,{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":400,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
          Delay(5000)
          #icon("@res:i8tqf393-ff8h-1bof-arhc-08u532i88nqe.png")
          bRet = UiElement.Exists({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","parentid":"dwData","aaname":"编辑","tableRow":"2"}]},{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":200})
          If bRet = True
              
              TracePrint("11修改成功~~~~："&id_no)
              #icon("@res:juoaoona-28j5-59pf-ajo2-veastu3ivnft.png")
              Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","parentid":"dwData","aaname":"编辑","tableRow":"2"}]},"left","click",5000,{"bContinueOnError":True,"iDelayAfter":200,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
              #icon("@res:pv30l4hu-eg79-g12u-50nu-sh7bad825umr.png")
              bRet1 = UiElement.Exists({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","parentid":"c1main","aaname":"完成"}]},{"bContinueOnError":True,"iDelayAfter":200,"iDelayBefore":200})
              If bRet1 = True
                  #icon("@res:a7dfde5i-h2al-e28f-rbnb-8ir8hht37ccu.png")
                  Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","parentid":"c1main","aaname":"完成"}]},"left","click",5000,{"bContinueOnError":True,"iDelayAfter":200,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
                  #icon("@res:dcoonj88-fde3-pbkp-ulev-7699f2sorgp1.png")
                  Keyboard.InputText({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"TEXTAREA"}]},"您的公交卡已制作完毕。",True,20,6000,{"bContinueOnError":True,"iDelayAfter":200,"iDelayBefore":200,"bSetForeground":True,"sSimulate":"message","bValidate":False,"bClickBeforeInput":False})
                  
                  
                  // dim count = 0
                  // #icon("@res:9bujp12u-6sna-o33f-5amf-u9dkvtca9ors.png")
                  // bRet2 = UiElement.Exists({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"A","aaname":"确定完成"}]},{"bContinueOnError":False,"iDelayAfter":300,"iDelayBefore":200})
                  // If bRet2 = true                
                  #icon("@res:k23ajud4-fnoh-4v89-s542-255ch9hig1id.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":True,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
                  //end if
                  
                  TracePrint("22修改成功~~~~："&id_no)
                  Delay(13000)
                  #icon("@res:s2tep3an-ngdr-33bt-ulu7-pfq1sfp96hmh.png")
                  Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","parentid":"filterMoreDiv"}]},"left","click",10000,{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
                  Delay(4000)
              Else
                  TracePrint("33原本是已经点击完成状态！！："&id_no)
                  #icon("@res:ueqrsmgd-r8g1-33ov-dqtk-pp8gif7iricu.png")
                  Mouse.Action({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"BUTTON","parentid":"c1main","aaname":"关闭"}]},"left","click",10000,{"bContinueOnError":True,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":True,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate","bMoveSmoothly":False})
                  Continue
              End If
          Else
              TracePrint("44原本就是修改成功的~~~~："&id_no)
              Delay(2000)
              Continue
          End If
      End If
      
  Next
  CollectGarbage