基础层:
from datetime import date, datetime, timedelta
from selenium import webdriver
from selenium.webdriver.common.by import By
import xlrd
driver = webdriver.Chrome("chromedriver.exe")
def get_driver():
return driver
def date_n(n):
return str(date.today() + timedelta(days=int(n)))
#方法未使用
def byname(element):
return driver.find_element('name', element)
#方法未使用
def xpath(element):
return driver.find_element(By.XPATH, element)
def open_url(url):
driver.get(url)
driver.maximize_window()
# ishaed 表示是否有标题 默认为False
def read_execl(filename, ishead=False):
xlsx = xlrd.open_workbook(filename)
sheet = xlsx.sheet_by_index(0)
data = []
for i in range(sheet.nrows):
if i == 0:
if ishead:
continue
data.append(sheet.row_values(i))
# print(sheet.row_values(1))
return data
def close_bower():
driver.quit(