python邮件发送正文-富文本

最新推荐文章于 2022-10-29 21:04:32 发布

Fighting-年轻人就该张牙舞爪

最新推荐文章于 2022-10-29 21:04:32 发布

阅读量492

点赞数

分类专栏： Python技术

本文链接：https://blog.csdn.net/weixin_43380311/article/details/118611450

版权

Python技术专栏收录该内容

102 篇文章 6 订阅

订阅专栏


import xlrd
import datetime

class _WriteExcel(object):
    def __init__(self):
        self.style_0 = xlwt.easyxf('font: bold on, color-index red, height 300;')
        self.style_1 = xlwt.easyxf('pattern: pattern solid, fore_colour green; font: height 300;')
        # 实例化句柄
        self.workbook = xlwt.Workbook(encoding='utf-8')
        self._add_sheet()

    def _add_sheet(self):
        self.sheet = self.workbook.add_sheet('爬虫监控概要', cell_overwrite_ok=True)

        # 列宽

        self.sheet.col(0).width = 256 * 20
        self.sheet.col(1).width = 256 * 20
        self.sheet.col(2).width = 256 * 20
        self.sheet.col(3).width = 256 * 20

    def write_head(self, row, column, value):
        self.sheet.write(row, column, value, self.style_0)

    def write_content(self, row, column, value):
        self.sheet.write(row, column, value, self.style_1)

    def save(self, file_name):
        self.workbook.save(file_name)

    def _make_html(self, file_name):
        """
        以行进行操作
        :param file_name:
        :return:
        """
        now = datetime.datetime.now().strftime('%Y-%m-%d')
        exc_data = xlrd.open_workbook(file_name)
        sheet = exc_data.sheet_by_index(0)
        nrows = sheet.nrows  # 表的行数

        tr = ""
        for i in range(1, nrows):  # 每一行 按单元格处理
            one_row_value = sheet.row_values(i)
            tip = ""
            for index, each_value in enumerate(one_row_value):
                if isinstance(each_value, float):
                    each_value = str(int(each_value))
                if index == 1 or index == 2:  # 第二列 > 0 高亮显示
                    if int(each_value) > 0:
                        tip = tip + "<td bgcolor=#00FF00>" + each_value + "</td>"
                    else:
                        tip += "<td>" + each_value + "</td>"
                else:
                    tip += "<td>" + each_value + "</td>"
            tr += "<tr>" + tip + "</tr>"
        table_header = '<table border="1" cellspacing="0" cellpadding="3" bordercolor="#000000">' \
                       '<caption>' \
                       '%s媒资发布端统计' \
                       '</caption>' % now
        table_part1 = '<tr bgcolor="#FFFF00" align="left">' \
                      '<th>媒资类型</th>' \
                      '<th>今日下载媒资</th>' \
                      '<th>今日发布媒资</th>' \
                      '<th>媒资发布总量</th>' \
                      '</tr>'
        html = "<html><h4>发布端媒资统计！</h4><body>'" + table_header + table_part1 + tr + "</table> </body></html>"

        return html

Fighting-年轻人就该张牙舞爪

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
python邮件发送正文-富文本

import xlrdimport datetimeclass _WriteExcel(object): def __init__(self): self.style_0 = xlwt.easyxf('font: bold on, color-index red, height 300;') self.style_1 = xlwt.easyxf('pattern: pattern solid, fore_colour green; font: height 3.
复制链接

扫一扫