Python3导出xls文件工具

Python3导出xls文件工具

1. 安装导出文件所需依赖包：如果安装比较慢可以参考之前文章更换下载源即可

   pip3 install xlwt
   

2. 示例

   """
   @Author  : 
   @Time    : 2020/12/25 12:39
   @Function: 导出xls文件工具
   """
   import xlwt
   
   from io import BytesIO
   from django.http import HttpResponse
   
   
   def down_load_logger_tools(header, data_list):
       """
       header = []
       data_list = [[], []]
       """
       # http连接方式
       response = HttpResponse(content_type='application/vnd.ms-excel')
       # filename xls文件名
       response['Content-Disposition'] = 'attachment;filename=logging.xls'
       # 编码格式
       wb = xlwt.Workbook(encoding='utf-8')
       # sheet名
       sheet = wb.add_sheet('操作日志记录表')
       # 设置xls文件表头颜色
       pattern = xlwt.Pattern()
       pattern.pattern = xlwt.Pattern.SOLID_PATTERN
       pattern.pattern_fore_colour = 5
       style = xlwt.XFStyle()
       style.pattern = pattern
   
       # 导出excel表头
       if header:
           for number, value in enumerate(header):
               sheet.write(0, number, value, style)
       else:
           return HttpResponse('header为空，导出xls文件失败')
   
       # 导出excel数据
       if data_list:
           _excel_row = 1
           for k, v in enumerate(data_list):
               for i, j in enumerate(v):
                   # 行　列　值
                   sheet.write(_excel_row, i, j)
               _excel_row += 1
           # 写出到IO
           output = BytesIO()
           wb.save(output)
           # 重新定位到开始
           output.seek(0)
           response.write(output.getvalue())
           return response
       else:
           return HttpResponse('导出xls文件失败')
    
   if __name__ == '__main__':
       header = ['name', 'age']
       data_list = [['小王', '24'], ['小李', '25']]
       down_load_logger_tools(header=header, data_list=data_list)