django install xls_table

1.导包

import xlwt
from django.http import HttpResponse

2.封装函数

def recharge_export(request):
    start_date = request.session.get('start_date')
    end_date = request.session.get('end_date')

    queryset = Recharge.objects.all()
    if start_date:
        queryset = queryset.filter(create_time__gte=start_date)
    if end_date:
        queryset = queryset.filter(create_time__lte=end_date)
    print(queryset.query)

    recharge_list = queryset.all()

    book = xlwt.Workbook(encoding='utf8')
    sheet = book.add_sheet(u'充值记录')
    col_list = ['订单号', '手机号', '类型', '充值时间', '充值金额', '剩余可退金额', '状态']

    for i in range(len(col_list)):
        sheet.write(0, i, col_list[i])

    for row, data in enumerate(recharge_list):
        sheet.write(row + 1, 0, data.out_trade_no)
        if data.user:
            sheet.write(row + 1, 1, data.user.telephone)
        else:
            sheet.write(row + 1, 1, '')
        sheet.write(row + 1, 2, data.recharge_type)
        sheet.write(row + 1, 3, data.create_time)
        sheet.write(row + 1, 4, data.total_fee)
        sheet.write(row + 1, 5, data.refundable_fee)
        sheet.write(row + 1, 6, data.status)

    response = HttpResponse(content_type='application/vnd.ms-excel')
    response['Content-Disposition'] = 'attachment; filename=recharge_log.xls'
    book.save(response)
    return response

3.哈哈哈，我自己能看懂就行