python - 在从 python 触发的电子邮件中将 pandas 数据框附加为 excel 文件
问题描述
我有一个熊猫数据框,它基本上是 sql 查询的结果。我想在从python触发的自动电子邮件中附加为xlsx,并且该excel文件应该提到数据框。如何才能做到这一点。
我可以成功发送没有附件的电子邮件,但不能发送附件。
import pandas as pd
data= pd.DataFrame(output of sqlquery) # this data is dataframe output of a sql query.
# import necessary packages
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
import smtplib
# create message object instance
msg = MIMEMultipart()
password = "password"
msg['From'] = "xyz@gmail.com"
msg['To'] = "abc@gmail.com"
msg['Subject'] = "Messgae"
server = smtplib.SMTP('smtp.gmail.com:587')
server.starttls()
# Login Credentials for sending the mail
server.login(msg['From'], password)
server.sendmail(msg['From'], msg['To'], msg.as_string())
我不想从文件位置附加 excel 文件。首先,必须将该数据框写入excel,然后附加。
解决方案
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
fromaddr = '@gmail.com'
toaddr = ['@gmail.com', '@gmail.com',
'@gmail.com']
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = ", ".join(toaddr)
msg['Subject'] = "Hello"
body = "Sample Mail"
msg.attach(MIMEText(body, 'plain'))
filename = "Data.xlsx"
attachment = open("C:\\Users\\Desktop\\file.xlsx",
"rb")
part = MIMEBase('application', 'octet-stream')
part.set_payload((attachment).read())
encoders.encode_base64(part)
part.add_header('Content-Disposition', "attachment; filename= %s" % filename)
msg.attach(part)
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "TYPEPASSWORD") #Type Password
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()