{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "表数据的行数为91,列数为2\n", "1 11794822649434107975\n", "2 11794822610343194660\n", "3 11794822584443367517\n", "4 11794822565963259947\n", "5 11794822565699022922\n", "6 11794822565447364615\n", "7 11794822565246034006\n", "8 11794822565216677917\n", "9 11794822564944048209\n", "10 11794822564927270948\n", "11 11794822564679807025\n", "12 11794822564650442822\n", "13 11794822564419760211\n", "14 11794822564117770335\n", "15 11794822564113571881\n", "16 11794822563870302277\n", "17 11794822563606065188\n", "18 11794822563606061089\n", "19 11794822563375378461\n", "20 11794822563333435457\n", "21 11794822563098554445\n", "22 11794822543263686738\n", "23 11794822491950571602\n", "24 11794822490675507289\n", "25 11794822490377707558\n", "26 11794822474674237441\n", "27 11794822458610049072\n", "28 11794822451718807606\n", "29 11794822444240367619\n", "30 11794822444068397105\n", "31 11794822411252162630\n", "32 11794822378691784767\n", "33 11794822369174909021\n", "34 11794821134514417726\n", "35 11794821129598693384\n", "36 11794819320947695684\n", "37 11794819311858642963\n", "38 11794818932647424069\n", "39 11794816766427815999\n", "40 11794816720122699835\n", "41 11794816716440104993\n", "42 11794816707707559948\n", "43 11794816704838656013\n", "44 11794816701361582109\n", "45 11794816693023305767\n", "46 11794816689835634737\n", "47 11794815182620876857\n", "48 11794814950390657101\n", "49 11794814939057643611\n", "50 11794814935995801671\n", "51 11794814852537540629\n", "52 11794814821025734689\n", "53 11794814815011102781\n", "54 11794814762888491027\n", "55 11794814746576842801\n", "56 11794814316601958474\n", "57 11794814300579717192\n", "58 11794814285660581912\n", "59 11794814284192571399\n", "60 11794814267016900666\n", "61 11794814260645752843\n", "62 11794814259467153426\n", "63 11794814242765434935\n", "64 11794814238688571416\n", "65 11794814217125650436\n", "66 11794814188063322141\n", "67 11794814181457289237\n", "68 11794814177149743170\n", "69 11794814149798682707\n", "70 11794814147940610103\n", "71 11794814146669735989\n", "72 11794814137962356767\n", "73 11794814134502056028\n", "74 11794814133474455559\n", "75 11794814133092769877\n", "76 11794814131868037199\n", "77 11794814119364816971\n", "78 11794814104173047877\n", "79 11794814080114516007\n", "80 11794814077321109574\n", "81 11794814076637442115\n", "82 11794814070358564923\n", "83 11794814070039801868\n", "84 11794814064218107931\n", "85 11794814059633729627\n", "86 11794814059004583971\n", "87 11794814051136069659\n", "88 11794814041791164418\n", "89 11794814038418944079\n", "90 11794814032739852385\n", "表数据的行数为91,列数为2\n" ] } ], "source": [ "# -*- coding:UTF-8 -*-\n", "from selenium import webdriver\n", "from selenium.webdriver.support.ui import Select\n", "from selenium.webdriver import ActionChains\n", "import time\n", "import xlrd\n", "import xlwt\n", "import re\n", "from xlutils.copy import copy\n", "from selenium.webdriver.common.keys import Keys\n", "from selenium.webdriver.support.ui import WebDriverWait\n", "import datetime\n", "import os\n", "from selenium.webdriver.support import expected_conditions as EC\n", "from selenium.webdriver.common.by import By\n", "from selenium.webdriver.support.wait import WebDriverWait\n", "import pandas as pd\n", "#获取基础信息\n", "name = '15888265981'\n", "password = 'Ff123456'\n", "option_chrome = webdriver.ChromeOptions()\n", "option_chrome.add_argument('--headless')\n", "A = 1\n", "for v in range(0,1000):\n", " try:\n", " http='https://m.f6car.cn/'\n", " #driver = webdriver.Chrome(chrome_options=option_chrome)\n", " driver = webdriver.Chrome(executable_path=r\"C:\\Users\\admin\\Desktop\\Python脚本\\chromedriver.exe\")\n", " driver.maximize_window()\n", " driver.implicitly_wait(2)\n", " driver.get(http)\n", "\n", " # 在输入框中输入账号和密码\n", " username = WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.XPATH, r'//*[@id=\"pane-username\"]/form/div[1]/div/div[1]/input')))\n", " enter = WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.XPATH, r'//*[@id=\"pane-username\"]/form/div[3]/div/button')))\n", " username.clear()\n", " username.send_keys(name)\n", " driver.find_element_by_xpath(r'//*[@id=\"pane-username\"]/form/div[2]/div/div[1]/input').send_keys(password)\n", " enter.click()\n", " time.sleep(2)#预设时间\n", " driver.find_element_by_xpath(\"//*[text()='长葛市顺达汽车销售服务有限公司']\").click() #点击公司\n", " time.sleep(5)#预设时间\n", " file = xlwt.Workbook()\n", " # table = file.add_sheet('sheet name', cell_overwrite_ok=True)\n", " #打开excel文件\n", " data = xlrd.open_workbook(r\"C:\\Users\\admin\\Desktop\\新建XLS 工作表 (6).xls\")\n", " # print(data)\n", " table = data.sheet_by_index(0) # 通过索引顺序获取\n", " h = table.nrows\n", " l = table.ncols\n", " print(u\"表数据的行数为%s,列数为%s\"%(h,l))\n", "\n", " for i in range(A,A+500):\n", " try:\n", " idMember =table.cell(i, 0).value #按行读取数据\n", " code_new =table.cell(i, 1).value #按行读取数据\n", " # idMembervin =table.cell(i, 1).value #按行读取数据\n", " https='https://yunxiu.f6car.cn/erp/view/index.html#/macan-view/cardManage/cardEdit/'+idMember #进入页面\n", " # driver.get(\"https://yunxiu.f6car.cn/erp/view/index.html#/\")\n", " driver.get(https)\n", " time.sleep(0.1)\n", " driver.get(https)\n", " time.sleep(0.3)\n", " try: \n", " # driver.find_element_by_xpath('//*[@id=\"app\"]/div/div/div/div/div/div/div/div/div/form/div/div/div/div/div/div/input').send_keys(code_new) # 输入卡号\n", " input_bos =driver.find_element_by_xpath('//*[@id=\"app\"]/div/div/div/div/div/div/div/div/div/form/div/div/div/div/div/div/input')\n", " # input_bos.send_keys(Keys.CONTROL, 'a')\n", " # input_bos.send_keys(Keys.BACK_SPACE)\n", " time.sleep(0.1)\n", " input_bos.clear()\n", " time.sleep(0.1)\n", " input_bos.send_keys(code_new)# 输入卡号\n", " time.sleep(0.1)\n", " driver.find_element_by_xpath('//*[@id=\"app\"]/div/div/div/div/div/div/button[1]/span').click() #点击保存\n", " time.sleep(0.1)\n", " print(i, idMember)\n", " A = A + 1\n", " except:\n", " driver.find_element_by_xpath('//*[@id=\"app\"]/div[3]/div/div[1]/div/span').click() # 新手引导\n", " time.sleep(0.1)\n", " except:\n", " pass\n", " except:\n", " driver.close()\n", " A = A + 1\n" ] } ], "metadata": { "kernelspec": { "display_name": "F6processing", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.4" }, "orig_nbformat": 4 }, "nbformat": 4, "nbformat_minor": 2 }