思路

1.將姓名和單號填入excel表格里面

2.讀取excel表格，將所有姓名存到ExeclName這個list中，單號存到ExeclId

3.selenium自動根據姓名搜索，點擊發貨

代碼

# -- coding: utf-8 --from selenium import webdriverimport timeimport xlwings as xwfrom selenium.common.exceptions import NoSuchElementExceptionbrowser = webdriver.Chrome()#輸入有贊賬號密碼def loginYouzan():  browser.get('https://www.youzan.com/v2/trade/order#list&p=1&goods_title=&type=all&state=tosend&orderby=book_time&order_es_tag=&tuanId=&showBanner=false&ext_type=&order=desc&page_size=20&disable_express_type=')  time.sleep(1)  browser.find_element_by_name('mobile').send_keys("username")  time.sleep(0.5)  browser.find_element_by_name('password').send_keys("password")#自動上傳單號def autoUploadId():  wb = xw.Book('upload.xlsx')  sht = xw.books['upload.xlsx'].sheets['Sheet1']  ExeclId = sht.range('C2').expand('down') # 從excel獲取id #從c2開始的底下所有列的值存到list rng1中  ExeclName = sht.range('B2').expand('down') # 從excel中獲取名字  print(ExeclId.value)  print(ExeclName.value)  time.sleep(5)  loginYouzan()  time.sleep(5)  redBg = browser.find_elements_by_class_name('dp-text')  time.sleep(1)  #redBg[1].click()  redBg[0].click()  time.sleep(1)  #browser.find_element_by_name("order_label").find_elements_by_tag_name("option")[2].click()  browser.find_element_by_name("order_label").find_elements_by_tag_name("option")[2].click()  i = 0  while i < len(ExeclName):    time.sleep(2)    browser.find_element_by_name('user_name').click()    browser.find_element_by_name('user_name').clear()    browser.find_element_by_name('user_name').send_keys(ExeclName[i].value) # 填入獲取到的名字    time.sleep(1)    browser.find_element_by_link_text('篩選').click() # 點擊篩選    time.sleep(2)    try:      submit = browser.find_element_by_link_text('發 貨')      if submit.is_displayed():        if submit.is_enabled():          submit.click() # 點擊發貨          time.sleep(3)          browser.find_element_by_class_name('js-check-all').click()          time.sleep(2)          browser.find_element_by_name("express_id").find_elements_by_tag_name("option")[5].click()          browser.find_element_by_name('express_no').send_keys(ExeclId[i].value) # 填入單號          print("第" + str(i) + "個客戶成功")          print('姓名: ' + ExeclName[i].value + "單號: " + ExeclId[i].value)          time.sleep(4)          # browser.find_element_by_link_text('保存').click() #點擊保存          browser.find_element_by_link_text('×').click()          #i = i + 1          browser.find_element_by_name('user_name').clear()      else:        continue    except NoSuchElementException as msg:      print(msg)    print("第" + str(i) + "個客戶失敗")    i = i + 1    print('姓名: ' + ExeclName[i].value + "單號: " + ExeclId[i].value)    time.sleep(0.5)def main():  #writeDataToExcel()  autoUploadId()if __name__ == '__main__':  main()