90 lines
3.8 KiB
Python
90 lines
3.8 KiB
Python
# -*- coding:UTF-8 -*-
|
|
from selenium import webdriver
|
|
from selenium.webdriver.support.ui import Select
|
|
from selenium.webdriver import ActionChains
|
|
import time
|
|
import xlrd
|
|
import xlwt
|
|
import re
|
|
from xlutils.copy import copy
|
|
from selenium.webdriver.common.keys import Keys
|
|
from selenium.webdriver.support.ui import WebDriverWait
|
|
import datetime
|
|
import os
|
|
from selenium.webdriver.support import expected_conditions as EC
|
|
from selenium.webdriver.common.by import By
|
|
from selenium.webdriver.support.wait import WebDriverWait
|
|
import pandas as pd
|
|
#获取基础信息
|
|
name = '15888265981'
|
|
password = 'Ff123456'
|
|
option_chrome = webdriver.ChromeOptions()
|
|
option_chrome.add_argument('--headless')
|
|
A = 0
|
|
for v in range(0,1000):
|
|
try:
|
|
http='https://m.f6car.cn/'
|
|
#driver = webdriver.Chrome(chrome_options=option_chrome)
|
|
driver = webdriver.Chrome(executable_path=r"C:\Users\admin\Desktop\Python脚本\chromedriver.exe")
|
|
driver.maximize_window()
|
|
driver.implicitly_wait(2)
|
|
driver.get(http)
|
|
|
|
# 在输入框中输入账号和密码
|
|
username = WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.XPATH, r'//*[@id="pane-username"]/form/div[1]/div/div[1]/input')))
|
|
enter = WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.XPATH, r'//*[@id="pane-username"]/form/div[3]/div/button')))
|
|
username.clear()
|
|
username.send_keys(name)
|
|
driver.find_element_by_xpath(r'//*[@id="pane-username"]/form/div[2]/div/div[1]/input').send_keys(password)
|
|
enter.click()
|
|
time.sleep(10)#预设时间
|
|
# driver.find_element_by_xpath("//*[text()='东港市金阳汽车修理修配厂']").click() #点击公司
|
|
time.sleep(10)#预设时间
|
|
file = xlwt.Workbook()
|
|
table = file.add_sheet('sheet name', cell_overwrite_ok=True)
|
|
#打开excel文件
|
|
data = xlrd.open_workbook(r"C:\Users\admin\Desktop\新建XLS 工作表 (2).xls")
|
|
print(data)
|
|
table = data.sheet_by_index(0) # 通过索引顺序获取
|
|
h = table.nrows
|
|
l = table.ncols
|
|
print(u"表数据的行数为%s,列数为%s"%(h,l))
|
|
|
|
for i in range(A,h):
|
|
idMember =table.cell(i, 0).value #按行读取数据
|
|
# idMembervin =table.cell(i, 1).value #按行读取数据
|
|
https='https://yunxiu.f6car.cn/kzf6/member/index.do?page=/view/index.html%23/car/edit/'+idMember #进入页面
|
|
driver.get(https)
|
|
time.sleep(3)
|
|
try:
|
|
driver.find_element_by_xpath("//*[text()=' 下一步']").click()
|
|
time.sleep(1)
|
|
driver.find_element_by_xpath("//*[text()=' 我知道了']").click()
|
|
except:
|
|
pass
|
|
#传值转换
|
|
#driver.switch_to.frame('weixin-page-iframe')
|
|
driver.find_element_by_xpath('//*[@maxlength="17"]').click() #点击VIN
|
|
time.sleep(1)
|
|
try:
|
|
driver.find_element_by_xpath('//*[@maxlength="4"]').click() #点击车牌
|
|
time.sleep(1)
|
|
driver.find_element_by_xpath('//*[@maxlength="17"]').click() #点击VIN
|
|
except:
|
|
pass
|
|
try:
|
|
driver.find_element_by_xpath(
|
|
'/html/body/div[3]/div/div[3]/button[1]/span').click() #点击确定
|
|
time.sleep(1)
|
|
except:
|
|
pass
|
|
driver.execute_script("window.scrollTo(0,document.body.scrollHeight)")
|
|
time.sleep(1)
|
|
driver.find_element_by_xpath("//*[text()='保存']").click() #点击保存
|
|
time.sleep(2)
|
|
print(i, idMember)
|
|
A = A + 1
|
|
except:
|
|
driver.close()
|
|
A = A + 1
|