前提条件：需要安装xlrd  :pip install xlrd

1.先写个module.py

#!/usr/bin/env python # -*- coding: utf-8 -*- import time class baidumodule():     def __init__(self,driver):         self.driver=driver     def login(self,values):         login_driver=self.driver         login_driver.get("https://www.baidu.com/")         login_driver.find_element_by_xpath("//*[@id='kw']").send_keys(values)         login_driver.find_element_by_xpath("//*[@id='su']").click()         time.sleep(3)         login_driver.find_element_by_xpath("//*[@id='kw']").clear()     def login_out(self):         self.driver.quit() 2.再来个调用的baidu_sousuo.py

#!/usr/bin/env python # -*- coding: utf-8 -*- from selenium import webdriver from module import baidumodule import xlrd,time driver=webdriver.Firefox() search =baidumodule(driver) data=xlrd.open_workbook("file.xlsx","rb") table=data.sheet_by_name("Sheet1") sheet = data.sheets()[0] nrows=sheet.nrows ncols=sheet.ncols row_list=[] for i in range(0,nrows):     row_datas=sheet.row_values(i)     row_list.append(row_datas)     print(row_list) for j in row_list:     print(j)     search.login(j)     time.sleep(3) 3.本地创建一个file.xlsx的表格，如下：