djanog导出csv文件

def xlsx_response(x_io):
    res = HttpResponse()
    res["Content-Type"] = "text/csv"
    res["Content-Disposition"] = 'filename="aa.xlsx"'
    res.write(x_io.getvalue())
    return res

 

import pandas as pd

if query_params.get('export'):
            values_list_order = queryset.values_list(
                'out_trade_no', 'user__shipping_addr__address', 'created_at', 'user__first_name', 'user__phone',
                'total_count', 'real_amount', 'pay_method', 'write_off__first_name', 'write_off_time', 'status',
            )
            df = pd.DataFrame(
                values_list_order, columns=[
                    '订单号', '配送地址', '创建时间', '姓名', '用户手机', '数量',
                    '实付金额', '付款方式', '核销人', '核销时间', '订单状态'
                ]
            )
            df['实付金额'] = df['实付金额'].apply(lambda x: x/100)
            df['付款方式'] = df['付款方式'].apply(lambda x: get_han_status(x, Order.PAY_METHOD_CHOICES))
            df['订单状态'] = df['订单状态'].apply(lambda x: get_han_status(x, Order.ORDER_STATUS_CHOICES))
            csv_io = io.StringIO()
            df.to_csv(csv_io, index=False)
            return xlsx_response(csv_io)