如何将一封电子邮件发送到Excel工作簿中的电子邮件地址列表？

import openpyxl
import smtplib
from email.mime.text import MIMEText

# 打开Excel文件
workbook = openpyxl.load_workbook('email_list.xlsx')
sheet = workbook.active

# 读取电子邮件地址列表
email_list = []
for cell in sheet['A']:
    email_list.append(cell.value)

# 设置电子邮件内容
subject = "这是一封测试邮件"
body = "这是邮件的正文内容"
sender_email = "your_email@example.com"
password = "your_password"

# 遍历电子邮件地址列表并发送邮件
for recipient_email in email_list:
    # 创建电子邮件消息
    message = MIMEText(body)
    message['Subject'] = subject
    message['From'] = sender_email
    message['To'] = recipient_email

    # 发送电子邮件
    with smtplib.SMTP('smtp.example.com', 587) as server:
        server.starttls()
        server.login(sender_email, password)
        server.send_message(message)