要捕捉Excel信息并通过电子邮件发送它们,可以使用Python的openpyxl库来读取Excel文件,然后使用smtplib库来发送电子邮件。
下面是一个示例代码,演示了如何使用openpyxl库读取Excel文件的内容,并使用smtplib库发送电子邮件。
import openpyxl
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
# 读取Excel文件的内容
def read_excel(file_path):
workbook = openpyxl.load_workbook(file_path)
sheet = workbook.active
data = []
for row in sheet.iter_rows(values_only=True):
data.append(row)
return data
# 发送电子邮件
def send_email(sender, receiver, subject, message):
smtp_server = "smtp.example.com"
smtp_port = 587
smtp_username = "your_username"
smtp_password = "your_password"
msg = MIMEMultipart()
msg["From"] = sender
msg["To"] = receiver
msg["Subject"] = subject
body = MIMEText(message, "plain")
msg.attach(body)
server = smtplib.SMTP(smtp_server, smtp_port)
server.starttls()
server.login(smtp_username, smtp_password)
server.send_message(msg)
server.quit()
# 主程序
def main():
file_path = "path/to/excel/file.xlsx"
sender = "sender@example.com"
receiver = "receiver@example.com"
subject = "Excel Data"
message = ""
data = read_excel(file_path)
for row in data:
message += "\t".join(str(cell) for cell in row) + "\n"
send_email(sender, receiver, subject, message)
if __name__ == "__main__":
main()
请确保在运行代码之前,你已安装了openpyxl和smtplib库,并且将代码中的文件路径、发件人、收件人、SMTP服务器等信息替换为你自己的信息。