基于Python-Windows环境的Excel页面截图并邮件正文发送

截图模块

#截图模块
def get_snapshot():
    #定义变量
    #excel文件的绝对位置
    excel_file=r'E:\L.xlsx'
    #输出图片的绝对位置
    output_png_path=r'E:\L.png'
    #excel的sheet名称
    excel_tb='每日销售'

    #注意要装excel软件,否则会报错
    excel = win32.Dispatch('Excel.Application')
    wb = excel.Workbooks.Open(excel_file)
    ws = wb.WorkSheets(excel_tb)  # 打开工作簿

    # 示例：截图的起始终止格
    start_cell = "A1"
    end_cell = "B48"

    #存放图片在excel中,否则直接剪贴板会报错
    paste_cell= "Z99"

    ws.Range(f"{start_cell}:{end_cell}").CopyPicture()  # 变成图片
    ws.Paste(ws.Range(paste_cell))  # 将图片黏贴在excel中

    ws.Shapes(ws.Shapes.Count).Copy()  # 图片至剪贴板
    img = ImageGrab.grabclipboard()  # 从剪贴板获取图片
    img.save(output_png_path)  # 图片保存
    wb.Save()  # excel保存
    wb.Close()
    print('输出图片:'+output_png_path)

邮件正文发送图片,并附带附件

 1 def attach_mail_module(mail_title,mail_content,mail_to_list,mail_ccto_list,attachment,attachment_file_name):
 2     print('==进入attach_mail_module模块==')
 3     
 4     #读取配置与密码,所有邮件信息都从配置文件来
 5     conf_file='e:\\p.txt'
 6     conf = configparser.ConfigParser()
 7     conf.read(conf_file,encoding="utf-8")
 8     mail_conf="mail_address_info"
 9     
10     abnormal_mail_reciever = conf.get(mail_conf,"mail_reciever")
11     smtp_address_ip = conf.get(mail_conf,"smtp_address_ip")
12     smtp_port = int(conf.get(mail_conf,"smtp_port"))
13     login_user_name = conf.get(mail_conf,"login_user_name")
14     login_passwd = conf.get(mail_conf,"login_passwd")
15     send_mail_from = conf.get(mail_conf,"send_mail_from")
16 
17     #设置主题,收件人,抄送人
18     msg = MIMEMultipart('mixed')
19     msg['Subject'] = Header(mail_title,'utf-8')
20     msg['From'] = send_mail_from
21     msg['To'] = ",".join(to_list)
22     msg['cc'] = ','.join(ccto_list)
23     receive = to_list
24     receive.extend(ccto_list)
25 
26     #设置附件(可以是中文名)
27     att = MIMEText(open(attachment, 'rb').read(), 'base64', 'utf-8') 
28     att["Content-Type"] = 'application/octet-stream'
29     att.add_header("Content-Disposition", "attachment", filename=("gbk", "", attachment_file_name+".xlsx"))
30     msg.attach(att) 
31     
32     #设置图片
33     content=mail_content
34     html_img = f'<p>{content}<br><img src="cid:image1"></br></p>' # html格式添加图片
35     f = open(r"E:\LHD6_base.png", 'rb')  #打开图片
36     msgimage = MIMEImage(f.read())
37     f.close()
38     msgimage.add_header('Content-ID', '<image1>')  # 设置图片
39     msg.attach(msgimage)
40     msg.attach(MIMEText(html_img,'html','utf-8'))  # 添加到邮件正文
41 
42     #发送邮件
43     smtp = smtplib.SMTP()
44     smtp.connect(smtp_address_ip,smtp_port)
45     smtp.login(login_user_name,login_passwd)
46     smtp.sendmail(send_mail_from, receive , msg.as_string())
47     smtp.quit()
48     print('==attach_mail_module结束==\n')