python读取Excel定时向企微群发送每日值班信息

ZzijUtcLym · 发表于 2025-2-7 12:43:09

媒介

近来要写一个python剧本完毕读与正在线文档上的实质，并天天按时收收此中的实质到企微机械人，完毕天天值班职员按时提醒。根本思路是使用BeautifulSoup库将正在线文档按时下载到当地后，截至处置；但是陷入的成就是没法主动化登录相企微文档、腾讯正在线文档，没有登录便没法下载！何如尔太菜，tx的考证又太多。。。厥后发明能够使用webdrive，可是这类情况下主动登录只可正在图形化界里体系中。。。
仍是使用当地文献吧，每月朝效劳器上传一下便OK了，目前找到佳的完毕办法补。
完毕

主要完毕二个功用，一是朝此中一个群里收收来日诰日值班职员战来日诰日值班职员并@相干职员，两是朝另外一个群收收二个值班人并@
既然多个使用便写个class
使用的Excel表格格局以下：

centos7上装置python3

centos7上装置python3
python代码

from openpyxl import Workbook,load_workbook
import datetime
import requests
classdutyCall:def__init__(self,mobile_number,duty_filename,webhook):
self.mobile_number = mobile_number #人名-号码获得表
self.mobile_number_list =[]#需要@的人脚机号汇合
self.duty_filename = duty_filename #读与的Excel文献职位
self.webhook =webhook #企微机械人地点defhaveOne(self,name):#检测该事变值班可否为空或者——if name =="——"or name =="None":return0else:return1defname2mobileNumber(self,name):#将值班人姓名转移为其脚机号用于@# mobile_number_list =[]while name.find(',')>-1:
name = name.replace(',','，')while name.find('(')>-1:
name = name.replace('(','（')if name.find('，')>-1:
onename = name.split('，')else:
namestr = name
onename =[]
onename.append(str(namestr))for one in onename:if one.find('（')>-1:
name_real = one[0:one.find('（')]else:
name_real = one
# print(name_real)if self.number2(str(self.mobile_number[name_real]))==0:
self.mobile_number_list.append(str(self.mobile_number[name_real]))#return self.mobile_number_listdefnumber2(self, number):# 鉴别@号码表可否已经有if self.mobile_number_list ==[]:return0for n in self.mobile_number_list:if n == number:return1return0defto_robot(self,message):#施行收收疑息给机械人
header ="Content-Type: application/json"
data ={"msgtype":"text","text":{"content": message,"mentioned_mobile_list": self.mobile_number_list
}}print(self.mobile_number_list)
r = requests.post(url=self.webhook, json=data)print(r.text)defdothings(self):#截至读与Excel，并挪用收收函数收收
wb = load_workbook(self.duty_filename)
sheet = wb['Sheet1']
rows = sheet.max_row
cols = sheet.max_column
# print(cols)
date =str(datetime.datetime.now())[0:10]# 截与时间 xxxx-xx-xx# date = "2023-03-09"print(date)
today ='**旧日值班：**'
to妹妹 ='**嫡值班：**'for i inrange(1, rows +1):if date ==str(sheet.cell(i,1).value)[0:10]:# 匹配当日止for x inrange(2, cols +1):# 该日每一列遍历if self.haveOne(str(sheet.cell(i, x).value)):# 检测目前列旧日可否有人
today = today +"\n"+str(sheet.cell(2, x).value)+"："+str(sheet.cell(i, x).value)
self.name2mobileNumber(str(sheet.cell(i, x).value))for y inrange(2, cols +1):if self.haveOne(str(sheet.cell(i +1, y).value)):
to妹妹 = to妹妹 +"\n"+str(sheet.cell(2, y).value)+"："+str(sheet.cell(i +1, y).value)print(today +"\n"+ to妹妹)
text = today +"\n"+ to妹妹
self.to_robot(text)defdothing_g4(self):#共dothings 但是只收收多少天且前二列的疑息
wb = load_workbook(self.duty_filename)
sheet = wb['Sheet1']
rows = sheet.max_row
cols = sheet.max_column
# print(cols)
date =str(datetime.datetime.now())[0:10]# 截与时间 xxxx-xx-xx# date = "2023-03-09"print(date)
today ='**旧日值班：**'for i inrange(1, rows +1):if date ==str(sheet.cell(i,1).value)[0:10]:# 匹配当日止for x inrange(2,4):# 该日每一列遍历if self.haveOne(str(sheet.cell(i, x).value)):# 检测目前列旧日可否有人
today = today +"\n"+str(sheet.cell(2, x).value)+"："+str(sheet.cell(i, x).value)
self.name2mobileNumber(str(sheet.cell(i, x).value))print(today )
text = today
self.to_robot(text)#企微机械人webhook
webhookyw ="https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=xxxxxxxx-xxx-xxx-xxxx-xxxxxxxxxxx"# webhookyw="https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx"#webhookg4="https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=xxxxxxxx-xxxxx-4804-xxxx-xxxxxxxxxx"
mobile_number ={#比较表人名-脚机号'aa':'11111111','bbb':'22222','cc':'3333','dd':'44','ee':'55','ff':'66','gg':'77','hh':'88'}
duty_filename ='C:/Users/Administrator/Desktop/值班.xlsx'#值班execl地点#duty_filename = '/zihban/值班.xlsx'
dutyCalleryw =dutyCall(mobile_number=mobile_number,duty_filename=duty_filename,webhook=webhookyw)
dutyCalleryw.dothings()
dutyCallerg4 =dutyCall(mobile_number=mobile_number,duty_filename=duty_filename,webhook=webhookg4)
dutyCallerg4.dothing_g4()