之前写过一篇关于如何用python实现腾讯文档自动打卡并定时执行,但现在tx把文档的跳转机制改了,不再是通过json显式跳转,因而也不能通过原先的方法对行列进行获取。在这里提供另一种方法。通过获取格子信息得到,通过F12开发者工具找到这个位置,然后定位目前所在位置,然后再根据当前日期来获取相对距离,然后再通过模拟键盘输入即可。与上一种方法不同之处,在于通过格子信息获取信息,而不是通过json跳转。
# 访问腾讯文档并填写ok
def visit_txt():
data = datetime.date.today()
day = data.day
mouth = data.month
year = data.year
# print(now)
h = 16 # 行号
# print(c)
url = "文档网址"
driver = webdriver.Chrome(options=chrome_options)
driver.get(url)
time.sleep(5)
elmet = driver.find_element_by_id("header-login-btn")
elmet.click()
driver.implicitly_wait(10)
driver.switch_to.frame("login_frame")
try:
elmet = driver.find_element_by_id("img_out_qq号")
elmet.click()
print("快捷登录成功")
content += "快捷登录成功\n"
except:
driver.find_element_by_id("switcher_plogin").click()
time.sleep(1)
driver.find_element_by_id("u").send_keys("")# qq
driver.find_element_by_id("p").send_keys("")# 密码
driver.find_element_by_id("login_button").click()
print("账号登录成功")
time.sleep(5)
# 转换frame
driver.switch_to.parent_frame()
# 获取登录过后格子所在位置
elmet = driver.find_element_by_class_name("formula-bar")
data = elmet.text
arrow = data[0]
row = re.findall("\d+", data)
if ord(arrow) > ord('B'): # 不能转换成int,转换成ascii
temp1 = ord(arrow) - ord('B')
for i in range(temp1):
ActionChains(driver).send_keys(Keys.LEFT).perform()
# time.sleep(0.5)
else:
ActionChains(driver).send_keys(Keys.RIGHT).perform()
# time.sleep(0.5)
for i in range(int(row[0])-1):
ActionChains(driver).send_keys(Keys.UP).perform()
# time.sleep(0.5)
elmet = driver.find_element_by_id('alloy-simple-text-editor')
txt = elmet.text
data = txt.split('.') # 获取列号
print(data)
# 3.0版本,通过键盘输入实现定位
time.sleep(5)
try:
elmet = driver.find_element_by_id('alloy-simple-text-editor')
txt = elmet.text
data = txt.split('.') # 获取列号
print(data)
if mouth > int(data[0]):
n = calendar.monthrange(year,int(data[0]))[1]
now = n+day-int(data[1])
else:
now = day-int(data[1])
# print(now)
for i in range(now):
ActionChains(driver).send_keys(Keys.RIGHT).perform()
# time.sleep(0.5)
for i in range(h-1):
ActionChains(driver).send_keys(Keys.DOWN).perform()
# time.sleep(0.5)
except:
driver.quit()
# 直接通过域名访问后直接填写
elmet = driver.find_element_by_id('alloy-simple-text-editor')
elmet.click()
# 开始先delete两个字符,测试用
elmet.send_keys(Keys.BACKSPACE)
elmet.send_keys(Keys.BACKSPACE)
time.sleep(1)
elmet.send_keys('ok') # 输入ok
time.sleep(2)
elmet.send_keys(Keys.ENTER)
elmet.send_keys(Keys.ENTER)
time.sleep(5)
driver.quit()