requests_html
chromedriver下载,下载后添加到环境变量。
http://npm.taobao.org/mirrors/chromedriver/
# -*- coding:utf-8 -*-
import time
import xlrd
import selenium
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
from time import sleep
from lxml import etree
from xlutils.copy import copy
def get_excel_data(sheetName, row, col=0):
excelDir = './data/单位名称.xls'
# 创建工作薄
workBook = xlrd.open_workbook(excelDir)
# 选择工作表
workSheet = workBook.sheet_by_name(sheetName)
return workSheet.cell(row,