|
本帖最后由 sheeboard 于 2020-4-30 18:41 编辑
我先前用python帮人写的,参考- import time
- from selenium import webdriver
- from selenium.webdriver.chrome.options import Options
- from selenium.webdriver.support.ui import Select
- from openpyxl import load_workbook
- options=Options()
- options.add_argument('--no-sandbox')
- driver = webdriver.Chrome(executable_path="/home/Documents/webdriver/chromedriver",chrome_options=options)
- wb=load_workbook('798txt.xlsx')
- data=wb['Sheet1']
- for row in data.iter_rows(min_row=2,max_col=5,max_row=252):
- code=row[1].value
- build=row[2].value
- door=row[3].value
- telephone=row[4].value
-
- driver.get(add_url)
-
- select = Select(driver.find_element_by_name('communityCode'))
- select.select_by_visible_text('××路89弄')
- select1 = Select(driver.find_element_by_name('communityAddress'))
- select1.select_by_visible_text('××路89弄')
- codenum=driver.find_element_by_xpath("//input[@class='text userCode']")
- telnum=driver.find_element_by_xpath("//input[@class='text telephone']")
- buildnum=driver.find_element_by_xpath("//input[@class='text buildingNumber']")
- doornum=driver.find_element_by_xpath("//input[@class='text doorNumber']")
- codenum.send_keys(code)
- telnum.send_keys(telephone)
- buildnum.send_keys(build)
- doornum.send_keys(door)
- driver.find_element_by_id('submit').click()
- driver.switch_to.alert.accept()
复制代码
用的是selenium,数据量很大本来是预计3个人做2个月的,自动填写半天就提交完了。如果是楼上说的构建post,那就更简单高效了。
|
|