【自动化】读取电子表格的用户名和密码进行登陆学习

import pyautogui
import time
from DrissionPage import ChromiumPage,ChromiumOptions
page = ChromiumPage()
co = ChromiumOptions()
import pandas as pd
page.get('https://zyjs.heb12333.cn')

df = pd.read_excel("user.xlsx")
print(df.iloc[0,1])
page.ele('x://input[@class="el-input__inner"]').input(df.iloc[0,0])
page.ele('x://div[@class="el-input el-input--mini el-input--prefix el-input--suffix"]/input').input(df.iloc[0,1])
time.sleep(10)
page.ele('x://button[@class="el-button login-btn el-button--primary el-button--mini"]').click()
time.sleep(1)
page.get('https://webzyjs.heb12333.cn/index.html#/v_courseDetails?courseId=NeS75S1e49zyllShwmP5G&trainplanId=33a530966b504e65a9780bc0eabc9ee3&platformId=251&fromPage=selected')
time.sleep(2)



for i in range(1,8):
    page.get(f'https://webzyjs.heb12333.cn/index.html#/v_video?platformId=251&trainplanId=33a530966b504e65a9780bc0eabc9ee3&courseId=HYJaaPPoYCglqaytKMECN&sectionId=HYJaaPPoYCglqaytKMECN1-{i}')
    time.sleep(10)
        # xloc,yloc = pyautogui.position()
        # print(xloc,yloc)
    # pyautogui.click(950,656,button='left')
    # iconloc = pyautogui.locateOnScreen('play.png')
    # time.sleep(1)
    # pyautogui.click(iconloc)
    pyautogui.click(675, 465, button='left')
    if i == 1:
        times = 2
        ztimes = times * 60
    if i == 2:
        times = 10
        ztimes = times * 60
    if i == 3:
        times = 12
        ztimes = times * 60
    if i == 4:
        times = 5
        ztimes = times * 60
    if i == 5:
        times = 29
        ztimes = times * 60
    if i == 6:
        times = 25
        ztimes = times * 60
    if i == 7:
        times = 23
        ztimes = times * 60
    time.sleep(ztimes)



    i += 1
    if i > 8:
        break