#encoding:gbk
import sys
reload(sys)
sys.setdefaultencoding( "gbk" )
import xlrd
import xlwt
import smtplib
import string
import os
from email.mime.text import MIMEText
mail_host="smtp.163.com"
mail_user="ccc"
mail_pass="cccpwd"
mail_postfix="163.com"
def send_mail(to_list,sub,content):
me="hello"+"<"+mail_user+"@"+mail_postfix+">"
msg = MIMEText(content,_subtype='plain',_charset='gb2312')
msg['Subject'] = sub
msg['From'] = me
msg['To'] = to_list
try:
server = smtplib.SMTP()
server.connect(mail_host)
server.login(mail_user,mail_pass)
server.sendmail(me, to_list, msg.as_string())
server.close()
print "".join(content)
return True
except Exception, e:
print "exception ......\r"
print str(e)
python操作excel 批量发送工资信息
最新推荐文章于 2024-08-06 16:58:24 发布
这篇博客介绍如何使用Python读取Excel文件(test.xls)并进行批量处理,结合邮件功能,实现工资信息的自动发送。通过实例展示了Python在数据处理和自动化办公中的应用。
摘要由CSDN通过智能技术生成