Python 代码不会使用 selenium 循环浏览网站

Question

我有一个带有商品编号的 Excel 工作表，想要循环遍历 Excel 电子表格中的每一行，并使用 selenium 在网站上搜索产品价格，然后将产品价格写入同一个电子表格中，但不知何故，循环不起作用

希望你能帮助我

'''

lastrow= 10
indx = 2
Artikelnumber = sheet.cell(row=indx, column=2).value

while indx > lastrow:

#Search
search_txt = driver.find_element(By.ID, 'suggestSearch')
search_txt.click()

#Number
search_txt.send_keys(Artikelnumber)
search_txt.send_keys(Keys.ENTER)
#Produktpreis
Produktpreis = driver.find_element(By.XPATH, '(//span[@class="priceValue  "])[1]' ).text


workbook = load_workbook(filename='test.xlsx')
sheet = workbook["test"]
sheet.cell(row=indx, column=8).value = Produktpreis

indx = indx + 1

'''

Answer 1

从这个问题你必须使用 openpyxl 模块

下面的代码将帮助你解决你的问题

import openpyxl

path1 = r'Excel Path'
wb1 = openpyxl.load_workbook(path1)  # this will open your excel file
ws1 = wb1.worksheets[0]  # this will open your excel sheet1
LastRowCount = ws1.max_row  # this will find max row from the excel
start_row_number = 2

for i in range(int(start_row_number), int(LastRowCount) + 1):

    # it will get data of row i which will increase upto maxrow and columnnumber which is fix in excel file of FromDateColumnNumber
    Artikelnumber = ws1.cell(row=i, column=2).value

    # Search
    search_txt = driver.find_element(By.ID, 'suggestSearch')
    search_txt.click()

    # Number
    search_txt.send_keys(Artikelnumber)
    search_txt.send_keys(Keys.ENTER)
    # Produktpreis
    Produktpreis = driver.find_element(
        By.XPATH, '(//span[@class="priceValue  "])[1]').text

    workbook = load_workbook(filename='Excel Path')
    sheet = workbook["test"]
    sheet.cell(row=i, column=8).value = Produktpreis
sheet.save()

希望这会有所帮助