<p>下面是创建带边框表的完整解决方案。</p>
<pre><code>table = ''
with open('result.csv') as csvFile:
reader = csv.DictReader(csvFile, delimiter=',')
table = '<tr>{}</tr>'.format(''.join(['<td class="cell">{}</td>'.format(header) for header in reader.fieldnames]))
for row in reader:
table_row = '<tr>'
for fn in reader.fieldnames:
table_row += '<td class="cell">{}</td>'.format(row[fn])
table_row += '</tr>'
table += table_row
html = """
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>html title</title>
<style type="text/css" media="screen">
table{
background-color: #000000;
empty-cells:hide;
Border:5px solid red;
}
td.cell{
background-color: white;
}
</style>
</head>
<html><body><p>Hi!</p>
<p>Here is your data.</p>
<table style="border: black 0.5px;">
%s
</table>
<p>Regards,</p>
<p>Python 3.5</p>
</body></html>""" % table
message = MIMEMultipart(
"alternative", None, [MIMEText(html,'html')])
message['Subject'] = "Some stats via mail"
message['From'] = 'a@abc.com'
message['To'] = 'b@abc.com'
sender = "a@abc.com"
receivers = ['b@abc.com']
try:
smtp_obj = smtplib.SMTP('mail.abc.com')
smtp_obj.sendmail(sender, receivers, message.as_string())
print ("Successfully sent email")
except SMTPException:
print ("Error: unable to send email")
</code></pre>
