excel.py

导出Excel
```
class ExcelReport(object):
    def __init__(self):
        self.wkbook = xlwt.Workbook()
        self.sheet_num = 0
        self.style_int = xlwt.XFStyle()
        self.style_percent = xlwt.XFStyle()
        self.style_int.num_format_str = "0"
        self.style_percent.num_format_str = '0.00%'

def header_style(self):
        # 字体样式
        font = xlwt.Font()
        font.name = 'Times New Roman'
        font.height = 12 * 20

# 背景颜色
        pattern = xlwt.Pattern()
        pattern.pattern = xlwt.Pattern.SOLID_PATTERN
        pattern.pattern_fore_colour = 22

# 边框样式
        border = xlwt.Borders()
        border.left = xlwt.Borders.THIN
        border.top = xlwt.Borders.THIN
        border.bottom = xlwt.Borders.THIN

# 初始化样式
        style = xlwt.XFStyle()
        style.font = font
        style.pattern = pattern
        style.borders = border
        return style

def _make_header(self, wksheet, headers):
        style = self.header_style()
        wksheet.row(0).height_mismatch = True
        wksheet.row(0).height = 30 * 20
        for i, val in enumerate(headers):
            width = 3000
            if len(val) >= 4:
                width = 4000
            if len(val) >= 7:
                width = 5000
            wksheet.col(i).width = width
            wksheet.write(0, i, val, style)

def make_report(self, title, headers, data):
        wksheet = self.wkbook.add_sheet(title)
        if not data:
            return
        self._make_header(wksheet, headers)
        for i, row in enumerate(data):
            wksheet.row(i + 1).height_mismatch = True
            wksheet.row(i + 1).height = 23 * 20
            for j, val in enumerate(row):
                if j in (9, 10, ):
                    wksheet.write(i + 1, j, val, self.style_percent)
                wksheet.write(i + 1, j, val)

def save(self):
        date = datetime.now().strftime("%Y%m%d")
        file_name = "故障影响范围报告-{date}.xls".format(date=date)
        self.wkbook.save(file_name)
        return file_name
```