问对excel文件的Flask响应导致excel响应损坏

EN

@app.route("/api/v1/downloadexcel", methods=["GET"])
def excel_download2():   
    date_from = request.args.get("date_from")
    date_to = request.args.get("date_to")

    try:
        data_to_create_excel= get_data(date_from, date_to)
      
        output = io.BytesIO()
        workbook = xlsxwriter.Workbook(output, {'in_memory': True})

        # workbook = xlsxwriter.Workbook('demo.xlsx')

        worksheet = workbook.add_worksheet('data_to_create_excel')
        headers = list(data_to_create_excel[0].keys()) if len(data_to_create_excel) else []
        rows = [data .values() for data in data_to_create_excel]
        for row_num, row_data in enumerate([headers , *rows]):
            for col_num, col_data in enumerate(row_data):
                worksheet.write(row_num, col_num, col_data)


        workbook.close()
        output.seek(0)
        return send_file(output, attachment_filename="output.xlsx", as_attachment=True)

        # return Response(output.getvalue(), mimetype="application/ms-excel",
        #                 headers={"Content-Disposition": "attachment;filename=employee_report.xlsx"})

        # self.send_response(200)
        # self.send_header("Access-Control-Expose-Headers", "Content-Disposition")
        # self.send_header('Content-Disposition', 'attachment; filename=test.xlsx')
        # self.send_header('Content-type',
        #                  'application/ms-excel')
        # self.end_headers()
        # self.wfile.write(output.read())
        # return

        # file_name = 'ore_data_{}.xlsx'.format(
        #     datetime.now().strftime('%d/%m/%Y'))
        # return jsonify([csv_headers]), 200
        # return send_file(output,
        #                  attachment_filename='your_filename.xlsx',
        #                  as_attachment=True)
        # return Response(
        #     output.getvalue(),
        #     # mimetype='application/ms-excel',
        #     headers={
        #         "Access-Control-Expose-Headers": "Content-Disposition",
        #         "Content-Disposition": 'attachment; filename=test.xlsx',
        #         'Content-type':
        #     'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
        #     },
        # )
        # return output.read(),200
    except Exception as e:
        print(e)