首页 > 解决方案 > Python,为什么硒脚本运行这么慢

问题描述

我正在运行一个脚本来登录网站并将信息提取到 Excel 中。它曾经运行平稳快速,但现在它只是SLOW和SLOW。运行.click()方法需要 15 秒,而过去只需要 2 秒。我想知道我的代码有什么问题会产生如此低效的结果吗?此外,我的 excel 文件在运行脚本后已损坏且无法打开。任何帮助将不胜感激。

from selenium import webdriver
import XLUtlis
from selenium.webdriver.common.keys import Keys

driver = webdriver.Chrome("C:\Users\XUPJ21WJH\Desktop\Testing\Drivers\chromedriver.exe")
driver.get("https://cmis2.cat.com/cmis_tc/Main.jsp?selectedURL=/CoreInquiry")
driver.maximize_window()
driver.find_element_by_name("cwsUID").send_keys("J1W")
driver.find_element_by_name("cwsPwd").send_keys("")
driver.find_element_by_id("submitButton").send_keys(Keys.ENTER)

path = "C://Users/XUPJ21WJH/Desktop/test.xlsx"

row = XLUtlis.getRowCount(path, 'Sheet1')

for r in range(2, row + 1):
    j19r = XLUtlis.readData(path, 'Sheet1', r, 1)
    driver.find_element_by_name("CcrNo").send_keys(j19r)
    driver.find_element_by_name("Search").click()
    driver.find_element_by_css_selector("#main_screen > form > table:nth-child(5) > tbody > tr.tableBodyOdd > td:nth-child(1) > table > tbody > tr > td:nth-child(1) > a > img").click()
    driver.find_element_by_xpath("//a[@href='Main.jsp?selectedURL=/CCRViewCredit']").click()
    number = driver.find_element_by_xpath("//tr[@class = 'tableBodyOdd']/td[position() = last() -1]").text
    XLUtlis.writeData(path, 'Sheet1', r, 3, number)
    driver.find_element_by_css_selector("#main_screen > form > div:nth-child(5) > table:nth-child(2) > tbody > tr > td > p > input[type=submit]:nth-child(1)").click()
    driver.find_element_by_css_selector("#main_screen > div > form > div:nth-child(6) > table:nth-child(10) > tbody > tr > td > input[type=SUBMIT]:nth-child(3)").click()
    driver.find_element_by_css_selector("#main_screen > form > center:nth-child(7) > input").click()

标签: python-2.7selenium

解决方案


推荐阅读