python发送带excel附件的邮件

在Python中，我们可以使用smtplib库来发送电子邮件，而pandas库则用于处理Excel文件。以下是发送带Excel附件的基本步骤：

1. 首先，你需要安装`email`, `pandas`, 和 `openpyxl` 或者 `xlsxwriter` 这些库，可以使用pip进行安装：

   pip install email pandas openpyxl # 或者 pip install xlsxwriter

2. 导入所需的模块：

import smtplib
import os
import pandas as pd
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication

3. 设置发件人、收件人邮箱地址以及SMTP服务器信息：

sender_email = 'your_email@example.com'
receiver_email = 'recipient_email@example.com'
smtp_server = 'smtp.example.com'
smtp_port = 587
username = 'your_username'
password = 'your_password'

4. 读取Excel文件并转换为MIMEApplication对象：

# 假设有一个名为'data.xlsx'的Excel文件
file_path = 'data.xlsx'
df = pd.read_excel(file_path)
attachment = MIMEApplication(open(file_path, 'rb').read(), _subtype='xls')
attachment.add_header('Content-Disposition', 'attachment', filename=os.path.basename(file_path))

5. 创建邮件实例，并设置邮件内容和附件：

msg = MIMEMultipart()
msg['From'] = sender_email
msg['To'] = receiver_email
msg['Subject'] = 'Email with Excel attachment'

body = 'Please find the attached Excel file.'
msg.attach(MIMEText(body))

msg.attach(attachment)

6. 登录SMTP服务器并发送邮件：

try:
    server = smtplib.SMTP(smtp_server, smtp_port)
    server.starttls()  # 如果SMTP需要加密连接
    server.login(username, password)
    text = msg.as_string()
    server.sendmail(sender_email, receiver_email, text)
    print("Email sent successfully!")
except Exception as e:
    print(f"Error sending email: {str(e)}")
finally:
    server.quit()