一个简单自动化测试程序(51job职位搜索,并将第一页结果存入Excel表里):
import time
import xlwt as x1
from selenium import webdriver
driver = webdriver.Chrome(
r'E:\chromedriver_win32\chromedriver.exe')
driver.get('http://www.51job.com')
ele = driver.find_element_by_id('kwdselectid')
ele.send_keys('python')
ele2 = driver.find_element_by_id('work_position_input')
ele2.click()
time.sleep(1)
# 取消当前的选择城市
ele3 = driver.find_elements_by_css_selector(
'#work_position_click_center_right_list_000000 em[class=on]')
for i in ele3:
i.click()
time.sleep(1)
# 点击杭州
driver.find_element_by_id(
'work_position_click_center_right_list_category_000000_080200').click()
time.sleep(3)
# 保存城市选择
driver.find_element_by_id('work_position_click_bottom_save').click()
# 点击搜索
element1 = driver.find_element_by_css_selector('.ush button')
driver.execute_script("arguments[0].click();", element1)
# 搜索结果
jobs = driver.find_elements_by_css_selector('#resultList div[class=el]')
# 创建一个Excel workbook对象
book = x1.Workbook()
# 增加一个sheet
sh = book.add_sheet('统计')
# 写入内容
row = 0
for job in jobs:
fields = job.find_elements_by_tag_name('span')
# stringFields = [field.text for field in fields] # 获取文本内容
# print('|'.join(stringFields))
col = 0
for field in fields:
text = field.text
print(text, end='')
sh.write(row, col, text)
col += 1
print('')
row += 1
# 保存文件
book.save(r'C:\Users\ignorance\Desktop\\51job.xls')
driver.quit()
本文介绍了一个使用Selenium和Python进行自动化测试的示例,该程序在51job网站上搜索Python相关职位,并将搜索结果的第一页数据保存到Excel表格中。涉及的技术包括Selenium WebDriver, Chrome浏览器驱动,以及xlwt库用于操作Excel。
1421





