#!/usr/bin/python
-- coding: UTF-8 --
smtplib 用于邮件的发信动作
import pandas as pd
import datetime
import smtplib
from email.mime.text import MIMEText
#from django.core.mail import EmailMultiAlternatives
from email.mime.image import MIMEImage
from email.mime.multipart import MIMEMultipart
from email.mime.application import MIMEApplication
email 用于构建邮件内容
from email.header import Header
from email.header import make_header
import os
import ssl
pd.set_option(‘display.max_colwidth’, -1) # 能显示的最大宽度, 否则to_html出来的地址就不全
import sys
reload(sys)
sys.setdefaultencoding(‘utf8’)
def get_html_msg():
“”"
1.构造html信息
“”"
df =pd.read_excel("")
df_html=df.to_html(escape=False)
head = \
"""
<head>
<meta charset="utf-8">
<STYLE TYPE="text/css" MEDIA=screen>
table.dataframe {
border-collapse: collapse;
border: 2px solid #a19da2;
/*居中显示整个表格*/
margin: auto;
}