Dajngo查询数据，查询出来之后生成Excel保存本地

class ExportExcel(APIView):

    def post(self, request, *args, **kwargs):

        export_time = request.data.get('startEndTime')

        user_id = request.data.get('user_id')

        if len(user_id) == 1 and 0 in user_id:

            message_content = StatisticsMessageCount.objects.filter(

            creat_time__range=(export_time[0] + " 00:00:00", export_time[1] + " 23:59:59"))

        elif len(user_id) > 1 and 0 in user_id:

            return JsonResponse({"code": 201, "message": "导出失败，请把全部选项去除!"})

        else:

            message_content = StatisticsMessageCount.objects.filter(user_id__in=user_id,

                                                                    creat_time__range=(export_time[0] + " 00:00:00",

                                                                                       export_time[1] + " 23:59:59"))

        wb = xlwt.Workbook(encoding='utf8')

        sheet = wb.add_sheet('sheet', cell_overwrite_ok=True)

        style_heading = xlwt.easyxf("""

                font:

                    height 220;

                align:

                    vert center,

                    horiz center;

                pattern:

                    pattern solid,

                    fore-colour 0x16;

                borders:

                    left thin,

                    right thin,

                    top thin,

                    bottom thin

                """)

        for i in range(0, len(message_content)):

            sheet.col(i).width = 256 * 30

            sheet.row(i).height = 20 * 80

        sheet.write(0, 0, '序号', style_heading)

        sheet.write(0, 1, '销售', style_heading)

        sheet.write(0, 2, '地区', style_heading)

        sheet.write(0, 3, 'Qustions', style_heading)

        sheet.write(0, 4, 'Answer', style_heading)

        sheet.write(0, 5, '解答人', style_heading)

        data_row = 0

        file_name = None

        for i in message_content:

            # 格式化datetime

            data_row += 1

            if len(user_id) > 1 or len(user_id) == 1 and 0 in user_id:

                file_name = "KPI统计"

            else:

                file_name = i.answerer

            sheet.write(data_row, 0, data_row)

            sheet.write(data_row, 1, i.sales)

            sheet.write(data_row, 2, i.area, )

            sheet.write(data_row, 3, i.problem)

            sheet.write(data_row, 4, i.answer)

            sheet.write(data_row, 5, i.answerer, )

        try:

            import os

            test_url = "http://127.0.0.1:8081"

            test_path = str('/medias/weekly/{}.xlsx'.format(file_name))

            ret = os.getcwd()

            wb.save(os.getcwd() + pord_path)

            return JsonResponse({"code": 200,

                                 "fileName": "{}.xlsx".format(file_name),

                                 "filePath": pord_url + pord_path })

        except Exception as e:

            print("异常: {}".format(e))

            return JsonResponse({"code": 201, "message": "导出失败，请关闭当前本地电脑打开的相同Excel重新导出!"})

前端 react 

   exportExcel = () => {

        const {startEndTime, selectedItems} = this.state

        let currentUser = JSON.parse(localStorage.getItem('userInfo'));

        const {dispatch} = this.props

        if (startEndTime.length === 2) {

            dispatch({

                type: 'GetStaticsCount/exportExcelData',

                payload: {

                    apiPath: '/wx/kpi_export/',

                    user_id:  currentUser.weights > 0? selectedItems:[currentUser.id],

                    startEndTime

                },

                callback: response => {

                    // 这块是关键， 根据后台api返回的文件路径，在本地可以正常a标签下载，在服务器上不可以，直接通过链接打开是文件流形式

                    axios.post(response.filePath, '', {

                        headers: {

                            'Content-Type': 'application/x-www-form-urlencoded', //请求的数据类型为form data格式

                        },

                        'responseType': 'blob'  //设置响应的数据类型为一个包含二进制数据的 Blob 对象，必须设置！！！

                    }).then(function (response) {

                        console.log(`数据流: ${response.data}`)

                        const blob = new Blob([response.data]);

                        const fileName = 'KPI统计.xlsx';

                        const linkNode = document.createElement('a');

                        linkNode.download = fileName; //a标签的download属性规定下载文件的名称

                        linkNode.style.display = 'none';

                        linkNode.href = URL.createObjectURL(blob); //生成一个Blob URL

                        document.body.appendChild(linkNode);

                        linkNode.click();  //模拟在按钮上的一次鼠标单击

                        URL.revokeObjectURL(linkNode.href); // 释放URL 对象

                        document.body.removeChild(linkNode);

                    }).catch(function (error) {

                        console.log(error);

                    });

                }

            })

        } else {

            message.error("请选择导出时间")

        }

    }