腾讯文档体温打卡python

腾讯文档体温打卡

import time
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from openpyxl import Workbook
from openpyxl.utils import get_column_letter
from selenium.webdriver.support.ui import Select
from selenium.webdriver.common.action_chains import ActionChains
#luosansui
driver = webdriver.Chrome()

driver.get("https://docs.qq.com/sheet")#腾讯文档网址
time.sleep(40)
driver.find_element_by_class_name('right-container').click()#点击登入按钮
time.sleep(10)
driver.switch_to.frame(driver.find_element_by_id('login_frame'))
driver.find_element_by_id('switcher_plogin').send_keys(Keys.TAB)
driver.find_element_by_id('switcher_plogin').send_keys(Keys.ENTER)
time.sleep(5)
driver.find_element_by_id('u').send_keys('账号')
driver.find_element_by_id('p').send_keys('密码')
driver.find_element_by_class_name('login_button').click()
time.sleep(30)
driver.switch_to.parent_frame()
action = ActionChains(driver)
action.key_down(Keys.CONTROL).send_keys('f').key_up(Keys.CONTROL).perform()
action.key_down(Keys.CONTROL).send_keys('f').key_up(Keys.CONTROL).perform()
action.key_down(Keys.CONTROL).send_keys('f').key_up(Keys.CONTROL).perform()
time.sleep(3)
driver.find_element_by_id('search-panel-input').send_keys('36.5.')#前一个数据，必须跟其他所有人不一样
time.sleep(3)
driver.find_element_by_class_name('dui-modal-close').click()
time.sleep(3)
driver.find_element_by_id('alloy-simple-text-editor').click()
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.BACK_SPACE)#删除并重写数据，防止重复
driver.find_element_by_id('alloy-simple-text-editor').send_keys('36.5')
time.sleep(3)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.TAB)#下一列
time.sleep(3)
driver.find_element_by_id('alloy-simple-text-editor').click()
driver.find_element_by_id('alloy-simple-text-editor').send_keys('36.7')#填写下一列的数据
time.sleep(3)
driver.find_element_by_id('alloy-simple-text-editor').send_keys(Keys.ENTER)
time.sleep(5)
driver.quit()

需要安装Chromedriver，查看浏览器版本，百度相应的Chromedriver。如果每天填两次，可以编译两个程序，交替执行，windows有计划任务。不懂可留言