网上找了很多资料，但是要生成自己能用的还是蛮麻烦的，碰到了很多坑
from datetime import datefrom datetime import timedeltafrom os import removefrom os import pathfrom win32com.client import Dispatchfrom openpyxl import load_workbookfrom itchat import auto_loginfrom itchat import get_chatroomsfrom itchat import search_chatroomsfrom itchat import sendfrom itchat import send_image#获得昨天的日期，并把名字改成0901这样的格式def getYesterday():today = date.today()oneday = timedelta(days = 1)yesterday = today - onedaydate_yes = yesterday.strftime("%m%d")return date_yes#获得日报的标准名称和报表路径def get_ribao():global ribao_nameribao_name = '【基础经营-实体1】：“乘风破浪”百日冲刺报表'+getYesterday()+'.xlsx'global path1path1 = path.abspath('.')+"\\"excel_path = path1 + ribao_namereturn excel_path#把报表中的需要通报的内容导出为图片def excel_export(excel_range, name):rng=ws.Range(excel_range)rng.CopyPicture()c=ws.ChartObjects().Add(0,0,rng.Width,rng.Height).Chartc.Parent.Select()c.paste()c.Export(path1 + name + '.png', "png")c.Parent.Delete()#获取通报的文字内容def get_body():wb = load_workbook(ribao_name)sheet1 = wb['门店通报']body = sheet1['A2'].valuereturn bodydef main():excel_path = get_ribao()xl = Dispatch('Excel.Application')xl.Visible = Falsewb = xl.Workbooks.Open(excel_path)global wsws = wb.Sheets('群通报')body = get_body()print('日通报内容获取成功')excel_export('A1:R18', 'store')excel_export('A20:R34', 'agent')print('图片导出成功')wb.Saved = True#不保存文件wb.Close()xl.Quit()#通过微信把2张图片发到固定的群里auto_login(hotReload=True)get_chatrooms() #如果是发到群里的消息或文件，必须保存群到通讯录才能用room_store = search_chatrooms(name = "自营厅店长群")[0]['UserName'] #不能发给自己room_agent = search_chatrooms(name = "浦东局专营渠道代理商群")[0]['UserName']room_qudao = search_chatrooms(name = "浦东实体渠道运营中心")[0]['UserName']# room_store = search_chatrooms(name = "周末报表群")[0]['UserName'] #不能发给自己# room_agent = search_chatrooms(name = "周末报表群")[0]['UserName']# room_qudao = search_chatrooms(name = "周末报表群")[0]['UserName']f = path1 + "store.png" #微信附件必须是英文g = path1 + "agent.png"send_image(f,toUserName=room_store)send_image(g,toUserName=room_agent)send(body, toUserName=room_qudao)print("发送成功")remove(f)remove(g)print("删除文件成功")if __name__ =="__main__":main()
