利用selenium获取51job上测试工程师的招聘信息，并生成excel表格

pip install selenium 
pip instal xlwt
from selenium import webdriver
import xlwt

driver = webdriver.Chrome()
driver.get("https://www.51job.com")
#在搜索框输入搜索类容：测试工程师
driver.find_element_by_id("kwdselectid").send_keys("测试工程师")
# 点击搜索的城市
driver.find_element_by_id("work_position_input").click()
# 去除已经选中的城市
eles = driver.find_elements_by_css_selector("#work_position_click_center_right_list_category_000000_020000 em[class=on]")
for ele in eles:
    ele.click()
# 选择城市之后点击确定
driver.find_element_by_id("work_position_click_bottom_save").click()
# 点击搜索按钮
driver.find_element_by_css_selector(".ush.top_wrap>div~button").click()
# 获取搜索到的每一条信息
jobs = driver.find_elements_by_css_selector(".el")
for job in jobs:
    fields = job.find_elements_by_tag_name("span")  #获取每条信息下的span
    for field in fields:
        stringfield = field.text
        print("|".join(stringfield))
# 把搜索到的内容通过excel 输出
new_workbook = xlwt.Workbook()  #新建一个工作簿
work_sheet = new_workbook.add_sheet("统计")   #新建一个工作表，起名叫“统计“
#循环把获取的内容输出到excel中
row = 0
for job in jobs:
    fields = job .find_elements_by_tag_name("span")
    col=0
    for field in fields:
        text = field.text
        print(text,end="")
        work_sheet.write(row,col,text)
        col +=1
    print('')
    row +=1
new_workbook.save("d:\\51job.xls")  #保存到d盘，起名叫51job