所有的Xpath值都輸入到Excel的E列中。
找到E列中的Xpath，并將D列中輸入的值輸入到Chrome中。
我怎樣才能使這段代碼成為一個回圈。
load_wb = load_workbook(filename, data_only=True)
load_ws = load_wb['apple']
elem=driver.find_element_by_xpath(load_ws['E2'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D2'].value)
elem=driver.find_element_by_xpath(load_ws['E3'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D3'].value)
elem=driver.find_element_by_xpath(load_ws['E4'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D4'].value)
elem=driver.find_element_by_xpath(load_ws['E5'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D5'].value)
elem=driver.find_element_by_xpath(load_ws['E6'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D6'].value)
elem=driver.find_element_by_xpath(load_ws['E7'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D7'].value)
elem=driver.find_element_by_xpath(load_ws['E8'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws['D8'].value)`。
uj5u.com熱心網友回復：
如果在Excel表中有7行，你的代碼可以簡單地改寫為：
load_wb = load_workbook(filename, data_only=True)
load_ws = load_wb['apple']
for i in range（2,9）。
elem=driver.find_element_by_xpath(load_ws['E' str（i）].value)
elem.send_keys(Keys.CONTROL 'a', Keys.DELETE)
elem.send_keys(load_ws['D' str（i）].value)
如果行的數量不一樣或者可以改變，你將不得不相應地改變for回圈中使用的范圍。
uj5u.com熱心網友回復：
使用范圍創建一個for回圈，然后使用格式呼叫i :
load_wb = load_workbook(filename, data_only=True)
load_ws = load_wb['apple']
for i in range(2,9):
elem=driver.find_element_by_xpath(load_ws[f'E{i}'].value)
elem.send_keys(Keys.CONTROL 'a',Keys.DELETE)
elem.send_keys(load_ws[f'D{i}'].value)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/312355.html
標籤：