python发邮件包含表格,在Python中在电子邮件正文中包含Excel表

这样做可能会解决您的问题：import openpyxl

from openpyxl import load_workbook

workbook = load_workbook(f)

worksheet = workbook.get_active_sheet()

html_data = """

XLSX to HTML demo

XLSX to HTML demo

"""

ws_range = worksheet.range('A1:H13')

for row in ws_range:

html_data += "

for cell in row:

if cell.value is None:

html_data += "

+ ' ' + "

else:

html_data += "

+ str(cell.value) + "

html_data += "

html_data += "

msg.attach(MIMEText(html_data))

with open(f, "rb") as fil:

part = MIMEApplication(

fil.read(),

Name=basename(f)

)

part['Content-Disposition'] = 'attachment; filename="{0}"'.format(basename(f))

msg.attach(part)