python 中 xlsxwriter 导出数据

xlsxwriter 将 Django 中存在的模型类中的表，导出到Excel中

import xlsxwriter
import datetime
from io import BytesIO
def excel_export(request):
    try:
        output = BytesIO()
        workbook = xlsxwriter.Workbook(output)
        
        target_sheet1 = workbook.add_worksheet("评测结果报表")     # 设置sheet 表1的名称
	    target_sheet1.write(0, 0, "评测结果报表")                 # 0,0 第一表格写入数据
        target_sheet1.merge_range('A1:C1', '评测结果报表')        # 设置合并单元格
        target_sheet1.set_row(0, 20)   				# 设置第1行的高度
        target_sheet1.set_column("A:A", 25)         # 设置第1列的宽度
       
        target_sheet1.write(1, 0, "id")
        target_sheet1.write(1, 1, "名称")
        target_sheet1.write(1, 2, "说明")
        
        projects_list = InstanceDetail.objects.all()
            i = 2
			for project in projects_list:
				target_sheet1.write(i, 0, u"{}".format(project.id))
				target_sheet1.write(i, 1, u"{}".format(project.name))
				target_sheet1.write(i, 2, u"{}".format(project.desc))
				i += 1
     
        date_day = datetime.datetime.now().strftime('%Y%m%d')
        file_name = "Report-{}.xlsx".format(date_day)

        workbook.close()
        xlsx_data = output.getvalue()
        response = HttpResponse(content_type='application/ms-excel')
        response['Content-Disposition'] = 'attachment; filename=%s' % file_name
        response.write(xlsx_data)
        print("报表下载成功")
        return response

    except Exception as e:
        response = HttpResponse()
        response.write("failure")
        print("failure")
        return response