task

有时候需要把数据（比如csv，或者\t分割）转换成html，方便查看。

jinja安装

pip install Jinja2
doc: http://docs.jinkan.org/docs/jinja2/index.html

过程

demo数据

1，2，3，4，5
6，7，8，9，10

把这两行数据渲染在表格里

创建your_template.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html lang="cmn-Hans-CN">
    <head>
        <title>
            format
        </title>
        <meta charset={{ encoding }}>
        <style type="text/css">
            body{FONT-SIZE: 13px; COLOR: #fffffff; LINE-HEIGHT: 19px;word-spacing:1px}
            table{border-collapse:collapse; border: 1px;} th{background: #3e83c9; border:
            1px solid #95bce2;font-weight:bold;} td{padding: 4px;border: 1px solid
            #95bce2;vertical-align: top;background-color:expression((this.parentElement.sectionRowIndex%2==1)?'#ECF6FC':'#ffffff');
            text-aligin:right;} td.name {font-weight:bold;} td.top {background: #d2e9ff;}
            td.bg {background: #f0f0f0;}
        </style>
    </head>
    <body>
        <table>
            <tr>
                <th nowrap="">
                    mt
                </th>
                <th nowrap="">
                    flow
                </th>
                <th nowrap="">
                    总消费
                </th>
                <th nowrap="">
                    关闭消费
                </th>
                <th nowrap="">
                    关闭占比
                </th>
                <th nowrap="">
                    打开占比
                </th>
            </tr>
            {% for item in data %}
            <tr>
                <td class="bg">
                    {{ item[0] }}
                </td>
                <td class="bg">
                    {{ item[1] }}
                </td>
                <td class="bg">
                    {{ item[2] }}
                </td>
                <td class="bg">
                    {{ item[3] }}
                </td>
                <td class="bg">
                    {{ item[4] }}
                </td>
                <td class="bg">
                    {{ item[5] }}
                </td>
            </tr>
            {% endfor %}
        </table>
    </body>

</html>

html生成脚本gen_html.py

 # encoding=utf-8
 import sys
 from jinja2 import Environment, FileSystemLoader

 env = Environment(loader=FileSystemLoader('./', encoding='utf-8'))

 data = []
 with open('./data') as f:
     for line in f:
         line = line.decode('gb18030', 'ignore').strip()
         cols = line.split(u'\t')
         data.append(cols)

 template = env.get_template('your_template.html')
 html = template.render(date=date, encoding='utf-8', data=data)  # unicode string
 print >> sys.stdout, html.encode('utf-8', 'ignore')

email

 python gen_html.py > temp.html

 email_to="xxx@xxx.com"
 /usr/lib/sendmail -t <<< "To: $email_to
 From: yyy@yyy.com
 Subject: demo
 Content-type: text/html; charset=utf-8
 $(cat temp.html)
 "