webpage.py 文件源码

def xls(self, requetst):
        from xlwt import Workbook,easyxf

        filename = self.filename_front + '.xls'
        wb = Workbook(encoding='utf-8')  
        wb_sheet = wb.add_sheet("sheet1")

        style = easyxf('pattern: pattern solid;')
        # ??????????

        for title in self.title_list:
            wb_sheet.write(0, self.title_list.index(title), title)

        for line in self.query_set :
            row_no = (self.query_set.index(line) + 1)
            col_no = 0
            for column in line[1:] :
                if re.search('^[0-9]{4}[-/][0-9]{2}[-/][0-9]{2}$', str(column)) :
                    column = date_convert(str(column) , '%Y?%m?%d?')
                elif re.search('^[0-9]{4}[-/][0-9]{2}[-/][0-9]{2}[ ]{0,1}[0-9]{2}:[0-9]{2}:[0-9]{2}$', str(column)) :
                    column = date_convert(str(column) , '%Y?%m?%d? %H:%M:%S')

                wb_sheet.write(row_no, col_no, column)
                col_no += 1
                # wb.write(?, ?, ??)
        response = HttpResponse(content_type='application/msexcel')
        response['Content-Disposition'] = 'attachment; filename=' + filename
        # ???????????????
        wb.save(response)
        return response