这样做可能会解决您的问题: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)