本文实例为大家分享了python定时发送邮件的具体代码,供大家参考,具体内容如下
全部代码如下:
import time from datetime import datetime from email.header import Header from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.utils import parseaddr, formataddr import xlrd from apscheduler.schedulers.blocking import BlockingScheduler from xlrd import xldate_as_tuple ISOTIMEFORMAT = '%Y%m%d' import smtplib def read_file(file_path): file_list = [] work_book = xlrd.open_workbook(file_path) sheet_data = work_book.sheet_by_name('Sheet1') print('now is process :', sheet_data.name) Nrows = sheet_data.nrows for i in range(1, Nrows): file_list.append(sheet_data.row_values(i)) return file_list def _format_addr(s): name, addr = parseaddr(s) return formataddr((Header(name, 'utf-8').encode(), addr)) def sendEmail(from_addr, password, to_addr, smtp_server, file_list): nowDate = str(time.strftime(ISOTIMEFORMAT, time.localtime())) html_content_start = ''' <html> <body> <p>hi,All:</p> <table border="0"width="95%"height="50%"cellpadding="1"style="margin:15px"cellspacing="1"bordercolor="#D3D3D3"bgcolor="#9F9F9F"> <tr bgcolor="#D3D3D3" style="margin:10px"> <th style="padding:6;font-size:16">工作事项</th> <th style="padding:6;font-size:16">负责人</th> <th style="padding:6;font-size:16">进度</th> <th style="padding:6;font-size:16">风险与问题</th> </tr> ''' for i in range(len(file_list)): work = file_list[i] workdata, person_name, progress, issue = str(work[0]), str(work[1]), str(work[2]), str(work[3]) if '.' in str(work[2]): # 填的数字 progress = "%.0f%%" % (work[2] * 100) # 浮点转成百分比 updateTime = xldate_as_tuple(work[4], 0) value = datetime(*updateTime) # 先转换为时间数组,然后转换为其他格式 timeStruct = time.strptime(str(value), "%Y-%m-%d %H:%M:%S") uptTime = str(time.strftime("%Y%m%d", timeStruct)) if uptTime != nowDate: raise RuntimeError('有人没有更新最新记录:' + str(work[1])) html_content_suffer = ''' <tr bgcolor="#FFFFFF" > <td style="padding:6;font-size:14">{workdata}</td> <td style="padding:6;font-size:14">{person_name}</td> <td style="padding:6;font-size:14">{progress}</td> <td style="padding:6;font-size:14">{issue}</td> </tr> '''.format(workdata=workdata.replace('\n', '<br>'), person_name=person_name, progress=progress, issue=issue) html_content_start += html_content_suffer html_content_end = ''' </table> </body> </html> ''' html_content = html_content_start + html_content_end try: msg = MIMEMultipart() msg.attach(MIMEText(html_content, 'html', 'utf-8')) msg['From'] = _format_addr('发送方 <%s>' % from_addr) msg['To'] = _format_addr(to_addr + '<%s>' % to_addr) msg['Subject'] = Header('主题' + nowDate, 'utf-8').encode() server = smtplib.SMTP_SSL(smtp_server, 465) server.login(from_addr, password) # 登录邮箱服务器 server.sendmail(from_addr, [to_addr], msg.as_string()) # 发送信息 server.quit() print("from_addr:" + str(from_addr), " to_addr:", to_addr, "已发送成功!") except Exception as e: print("发送失败" + e) def job(): root_dir = 'D:\\develop\\python\\file' file_path = root_dir + "\\excel.xlsx" from_addr = 'aaa@163.com' # 邮箱登录用户名 password = 'mima' # 登录密码 smtp_server = 'smtp.com' # 服务器地址,默认端口号25 to_addr = 'aaa@163.com' # 接收方邮箱 file_list = read_file(file_path) sendEmail(from_addr, password, to_addr, smtp_server, file_list) print('发送完成') if __name__ == '__main__': # 该示例代码生成了一个BlockingScheduler调度器,使用了默认的任务存储MemoryJobStore,以及默认的执行器ThreadPoolExecutor,并且最大线程数为10。 # BlockingScheduler:在进程中运行单个任务,调度器是唯一运行的东西 scheduler = BlockingScheduler() # 采用阻塞的方式 # 采用corn的方式,每天18点发送 scheduler.add_job(job, 'cron', hour='18') ''' year (int|str) – 4-digit year month (int|str) – month (1-12) day (int|str) – day of the (1-31) week (int|str) – ISO week (1-53) day_of_week (int|str) – number or name of weekday (0-6 or mon,tue,wed,thu,fri,sat,sun) hour (int|str) – hour (0-23) minute (int|str) – minute (0-59) econd (int|str) – second (0-59) start_date (datetime|str) – earliest possible date/time to trigger on (inclusive) end_date (datetime|str) – latest possible date/time to trigger on (inclusive) timezone (datetime.tzinfo|str) – time zone to use for the date/time calculations (defaults to scheduler timezone) * any Fire on every value */a any Fire every a values, starting from the minimum a-b any Fire on any value within the a-b range (a must be smaller than b) a-b/c any Fire every c values within the a-b range xth y day Fire on the x -th occurrence of weekday y within the month last x day Fire on the last occurrence of weekday x within the month last day Fire on the last day within the month x,y,z any Fire on any matching expression; can combine any number of any of the above expressions ''' scheduler.start()
表格如下:
如果放在linux系统中执行,上述脚本不能执行成功,是因为对编码等有要求,全部更新代码如下:
#coding=utf-8 import time from datetime import datetime from email.header import Header from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.utils import parseaddr, formataddr import sys import xlrd from apscheduler.schedulers.blocking import BlockingScheduler from xlrd import xldate_as_tuple ISOTIMEFORMAT = '%Y%m%d' import smtplib import logging logging.basicConfig() def read_file(file_path): file_list = [] work_book = xlrd.open_workbook(file_path) sheet_data = work_book.sheet_by_name('Sheet1') print('now is process :', sheet_data.name) Nrows = sheet_data.nrows for i in range(1, Nrows): file_list.append(sheet_data.row_values(i)) return file_list def _format_addr(s): name, addr = parseaddr(s) return formataddr((Header(name, 'utf-8').encode(), addr)) def sendEmail(from_addr, password, to_addr, smtp_server, file_list): nowDate = str(time.strftime(ISOTIMEFORMAT, time.localtime())) html_content_start = ''' <html> <body> <p>hi,All:</p> <table border="0"width="95%"height="50%"cellpadding="1"style="margin:15px"cellspacing="1"bordercolor="#D3D3D3"bgcolor="#9F9F9F"> <tr bgcolor="#D3D3D3" style="margin:10px"> <th style="padding:6;font-size:16">工作事项</th> <th style="padding:6;font-size:16">负责人</th> <th style="padding:6;font-size:16">进度</th> <th style="padding:6;font-size:16">风险与问题</th> </tr> ''' for i in range(len(file_list)): work = file_list[i] workdata, person_name, progress, issue = str(work[0]), str(work[1]), str(work[2]), str(work[3]) if '.' in str(work[2]): # 填的数字 progress = "%.0f%%" % (work[2] * 100) # 浮点转成百分比 updateTime = xldate_as_tuple(work[4], 0) value = datetime(*updateTime) # 先转换为时间数组,然后转换为其他格式 timeStruct = time.strptime(str(value), "%Y-%m-%d %H:%M:%S") uptTime = str(time.strftime("%Y%m%d", timeStruct)) if uptTime != nowDate: raise RuntimeError('有人没有更新最新记录:' + str(work[1])) html_content_suffer = ''' <tr bgcolor="#FFFFFF" > <td style="padding:6;font-size:14">{workdata}</td> <td style="padding:6;font-size:14">{person_name}</td> <td style="padding:6;font-size:14">{progress}</td> <td style="padding:6;font-size:14">{issue}</td> </tr> '''.format(workdata=workdata.replace('\n', '<br>'), person_name=person_name.replace('\n', '<br>'), progress=progress.replace('\n', '<br>'), issue=issue.replace('\n', '<br>')) html_content_start += html_content_suffer html_content_end = ''' </table> </body> </html> ''' html_content = html_content_start + html_content_end try: msg = MIMEMultipart() msg.attach(MIMEText(html_content, 'html', 'utf-8')) msg['From'] = _format_addr('发送方 <%s>' % from_addr) msg['To'] = _format_addr(to_addr + '<%s>' % to_addr) msg['Subject'] = Header('主题' + nowDate, 'utf-8').encode() server = smtplib.SMTP_SSL(smtp_server, 465) server.login(from_addr, password) # 登录邮箱服务器 server.sendmail(from_addr, [to_addr], msg.as_string()) # 发送信息 server.quit() print("from_addr:" + str(from_addr), " to_addr:", to_addr, "已发送成功!") except Exception as e: print("发送失败" + e) def job(): root_dir = 'D:\\develop\\python\\file' file_path = root_dir + "\\excel.xlsx" from_addr = 'aaa@163.com' # 邮箱登录用户名 password = 'mima' # 登录密码 smtp_server = 'smtp.com' # 服务器地址,默认端口号25 to_addr = 'aaa@163.com' # 接收方邮箱 file_list = read_file(file_path) sendEmail(from_addr, password, to_addr, smtp_server, file_list) print('发送完成') if __name__ == '__main__': # 该示例代码生成了一个BlockingScheduler调度器,使用了默认的任务存储MemoryJobStore,以及默认的执行器ThreadPoolExecutor,并且最大线程数为10。 # BlockingScheduler:在进程中运行单个任务,调度器是唯一运行的东西 scheduler = BlockingScheduler() # 采用阻塞的方式 reload(sys) sys.setdefaultencoding("utf8") # 采用corn的方式 scheduler.add_job(job, 'cron', hour='21', minute='0') ''' year (int|str) – 4-digit year month (int|str) – month (1-12) day (int|str) – day of the (1-31) week (int|str) – ISO week (1-53) day_of_week (int|str) – number or name of weekday (0-6 or mon,tue,wed,thu,fri,sat,sun) hour (int|str) – hour (0-23) minute (int|str) – minute (0-59) econd (int|str) – second (0-59) start_date (datetime|str) – earliest possible date/time to trigger on (inclusive) end_date (datetime|str) – latest possible date/time to trigger on (inclusive) timezone (datetime.tzinfo|str) – time zone to use for the date/time calculations (defaults to scheduler timezone) * any Fire on every value */a any Fire every a values, starting from the minimum a-b any Fire on any value within the a-b range (a must be smaller than b) a-b/c any Fire every c values within the a-b range xth y day Fire on the x -th occurrence of weekday y within the month last x day Fire on the last occurrence of weekday x within the month last day Fire on the last day within the month x,y,z any Fire on any matching expression; can combine any number of any of the above expressions ''' scheduler.start()
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
暂无评论...
稳了!魔兽国服回归的3条重磅消息!官宣时间再确认!
昨天有一位朋友在大神群里分享,自己亚服账号被封号之后居然弹出了国服的封号信息对话框。
这里面让他访问的是一个国服的战网网址,com.cn和后面的zh都非常明白地表明这就是国服战网。
而他在复制这个网址并且进行登录之后,确实是网易的网址,也就是我们熟悉的停服之后国服发布的暴雪游戏产品运营到期开放退款的说明。这是一件比较奇怪的事情,因为以前都没有出现这样的情况,现在突然提示跳转到国服战网的网址,是不是说明了简体中文客户端已经开始进行更新了呢?
更新日志
2024年12月24日
2024年12月24日
- 小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]
- 群星《欢迎来到我身边 电影原声专辑》[320K/MP3][105.02MB]
- 群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨][480.9MB]
- 雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓[WAV+CUE][463M]
- 群星《2024好听新歌42》AI调整音效【WAV分轨】
- 王思雨-《思念陪着鸿雁飞》WAV
- 王思雨《喜马拉雅HQ》头版限量编号[WAV+CUE]
- 李健《无时无刻》[WAV+CUE][590M]
- 陈奕迅《酝酿》[WAV分轨][502M]
- 卓依婷《化蝶》2CD[WAV+CUE][1.1G]
- 群星《吉他王(黑胶CD)》[WAV+CUE]
- 齐秦《穿乐(穿越)》[WAV+CUE]
- 发烧珍品《数位CD音响测试-动向效果(九)》【WAV+CUE】
- 邝美云《邝美云精装歌集》[DSF][1.6G]
- 吕方《爱一回伤一回》[WAV+CUE][454M]