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

截图模块

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

#截图模块 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)

　

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

def attach_mail_module(mail_title,mail_content,mail_to_list,mail_ccto_list,attachment,attachment_file_name):
    print('==进入attach_mail_module模块==')
    
    #读取配置与密码,所有邮件信息都从配置文件来
    conf_file='e:\\p.txt'
    conf = configparser.ConfigParser()
    conf.read(conf_file,encoding="utf-8")
    mail_conf="mail_address_info"
    
    abnormal_mail_reciever = conf.get(mail_conf,"mail_reciever")
    smtp_address_ip = conf.get(mail_conf,"smtp_address_ip")
    smtp_port = int(conf.get(mail_conf,"smtp_port"))
    login_user_name = conf.get(mail_conf,"login_user_name")
    login_passwd = conf.get(mail_conf,"login_passwd")
    send_mail_from = conf.get(mail_conf,"send_mail_from")

    #设置主题,收件人,抄送人
    msg = MIMEMultipart('mixed')
    msg['Subject'] = Header(mail_title,'utf-8')
    msg['From'] = send_mail_from
    msg['To'] = ",".join(to_list)
    msg['cc'] = ','.join(ccto_list)
    receive = to_list
    receive.extend(ccto_list)

    #设置附件(可以是中文名)
    att = MIMEText(open(attachment, 'rb').read(), 'base64', 'utf-8') 
    att["Content-Type"] = 'application/octet-stream'
    att.add_header("Content-Disposition", "attachment", filename=("gbk", "", attachment_file_name+".xlsx"))
    msg.attach(att) 
    
    #设置图片
    content=mail_content
    html_img = f'<p>{content}<br><img src="cid:image1"></br></p>' # html格式添加图片
    f = open(r"E:\LHD6_base.png", 'rb')  #打开图片
    msgimage = MIMEImage(f.read())
    f.close()
    msgimage.add_header('Content-ID', '<image1>')  # 设置图片
    msg.attach(msgimage)
    msg.attach(MIMEText(html_img,'html','utf-8'))  # 添加到邮件正文

    #发送邮件
    smtp = smtplib.SMTP()
    smtp.connect(smtp_address_ip,smtp_port)
    smtp.login(login_user_name,login_passwd)
    smtp.sendmail(send_mail_from, receive , msg.as_string())
    smtp.quit()
    print('==attach_mail_module结束==\n')