Python根据excel 自动发邮件

Python根据excel 自动发邮件--自动化小工具

import smtplib
from email.mime.text import MIMEText #邮件内容
from openpyxl import load_workbook  # excel库
from email.header import Header  # 邮件抬头

# 加载excel文件,data_only=True是只取数值 excel 文件地址可改，注意在同一文件夹
wb = load_workbook('case .xlsx', data_only=True)
sheet = wb.active  # 激活当前excel的表格

count = 0
table_col_html = '<thead>'  # HTML表头，成对出现
for row in sheet.iter_rows(min_row=1):
    count += 1
    if count == 1:  # first row
        for col in row:
            table_col_html += f'<th>{col.value}</th>'
        table_col_html += '</thead>'
        continue
    else:
        row_text = "<tr>"
        for cell in row:
            row_text += f"<td>{cell.value}</td>"
        row_text += "</tr>"  # 注意循环 丢了加号了
        name = row[2]
        staff_email