平台:
chrome,QQ
说明:
班委会提供一个腾讯文档链接,把找到自己的部分,把今天的体温填写完成。
所用库:
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from lxml import etree
import tkinter as tk
import requests
import random
import pyautogui
import pyperclip
import re
import os
import time
from PIL import Image
任务分解:
1.登录腾讯文档页面
2.准确找到学号位置
3.填写数据
4.生成exe
代码:
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from lxml import etree
import tkinter as tk
import requests
import random
import pyautogui
import pyperclip
import re
import os
import time
from PIL import Image
##https://docs.qq.com/sheet/DS0VCUG9NeUhLWHNY?tab=BB08J2
url = ""
selenium_path = "C:\Users\XC\AppData\Local\Google\Chrome\Application\chromedriver.exe" #chromedriver.exe位置
sid=[]
def sele():
browser = webdriver.Chrome(selenium_path)
browser.maximize_window()
return browser
def response(browser):
# 登录模块,账号密码输入,点击
print(url)
browser.get(url)
vis = 0
# 登录尝试
denglu(browser)
time.sleep(4)
print(browser.title)
#browser.find_element_by_xpath('//body/header/div/div/div/div/div/div/div/div/div/div/div/div[@class="toolbar-menu-button-more toolbar-inline-block"]').click()
for i in sid:#填写数据
time.sleep(1)
browser.find_element_by_id('sheet-search-button').click()
time.sleep(1)
browser.find_element_by_xpath('//body/div/div/div/div/div/input[@class="dui-input-input dui-input-input-default"]').send_keys(i)
time.sleep(1)
browser.find_element_by_xpath('//body/div/div/div/div/div//div[@class="dui-button-container"]').click()
time.sleep(1)
pyautogui.typewrite('\t',interval=0.25)
pyautogui.typewrite('\t',interval=0.25)
pyautogui.typewrite('\t',interval=0.25)
pyautogui.typewrite('\t',interval=0.25)
pyautogui.typewrite('\t',interval=0.25)
time.sleep(1)
for i in range(1,4):
tomorrow=['36.2','36.3','36.4','36.5','36.6','36.7','36.8']
a=random.choice(tomorrow)
pyautogui.typewrite(a,interval=0.25)
pyautogui.typewrite('\t',interval=0.25)
pyperclip.copy('无')
pyautogui.hotkey('ctrl','v',interval=0.25)
pyautogui.typewrite('\t')
time.sleep(2)
browser.quit()
def denglu(browser):#登录模块
time.sleep(5)
browser.find_element_by_id('header-login-btn').click()
time.sleep(3)
browser.switch_to.frame('login_frame')
time.sleep(3)
browser.find_element_by_id('img_out_1071949367').click()
return True
def window():#窗口模块
window = tk.Tk()
window.title('robot_print')
window.geometry('1000x500')
l = tk.Label(window, text='!Show Time!', bg='green', font=('Arial', 12), width=30, height=2)
# 说明: bg为背景,font为字体,width为长,height为高,这里的长和高是字符的长和高,比如height=2,就是标签有2个字符这么高
# 第5步,放置标签
l.pack()
var_usr_name = tk.StringVar()
tk.Label(window, text='Url:',font=('Arial', 14)).place(x=325, y=100)
tk.Entry(window, textvariable=var_usr_name, font=('Arial', 14)).place(x=375,y=100)
var_usr_id = tk.StringVar()
tk.Label(window, text='ID:',font=('Arial', 14)).place(x=325, y=150)
tk.Entry(window, textvariable=var_usr_id, font=('Arial', 14)).place(x=375,y=150)
def hit_me():
global url
url = var_usr_name.get()
global sid
sid = var_usr_id.get().split(' ')
print(sid)
browser = sele()
response(browser)
b = tk.Button(window, text='确定', font=('Arial', 12), width=10, height=1, command=hit_me).place(x=450,y=225)
window.mainloop()
if __name__ == '__main__':
window()
转EXE:
缺陷:
1.对chromedriver.exe位置有限制
2.必须登录QQ才能使用
总结:
实测好用,一个人可以填一个宿舍的,如果加上多线程,可以快速填一个班的。有建议欢迎表达。
QQ:1071949367,交个朋友!