【django基础】django接口 异步ajax请求 导出数据库成excel表(包裹前端后端)

py文件：

from django.utils.http import urlquote

from rest_framework.views import APIView

from django.shortcuts import render, redirect, HttpResponse

from dal import models

from django.http import JsonResponse, FileResponse, StreamingHttpResponse

import os

import xlwt

BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) # C:\Users\user\Desktop\DownTest

class fileShow(APIView):

    def get(self, request):

        message = {}

        userinfo = models.UserInfo.objects.all()

        workbook = xlwt.Workbook(encoding='utf-8')  # 新建工作簿\

        sheet1 = workbook.add_sheet("用户表")  # 新建sheet

        sheet1.write(0, 0, "ID")  # 第1行第1列数据

        sheet1.write(0, 1, "用户名")  # 第1行第1列数据

        sheet1.write(0, 2, "密码")  # 第1行第1列数据

        sheet1.write(0, 3, "创建时间")  # 第1行第1列数据

        path = BASE_DIR + "\\utils\\username.xlsx" # 储存路径

        excel_row = 1

        for obj in userinfo:

            data_id = obj.id

            data_username = obj.username

            data_password = obj.password

            data_time = obj.create_time

            sheet1.write(excel_row, 0, data_id)

            sheet1.write(excel_row, 1, data_username)

            sheet1.write(excel_row, 2, data_password)

            sheet1.write(excel_row, 3, str(data_time))

            excel_row += 1

            workbook.save(path)

        file = open(path,'rb')   # 字符串替换成文件

        print("file",file.name)

        # file_names = file.name.split('/')[-1]

        # print("file_names",file_names)

        response = FileResponse(file)

        response['Content-Type'] = 'application/octet-stream'

        response['Content-Disposition'] = "attachment;filename={}".format(urlquote(path)) # 字符串替换成下载文件

        print(response)

        return response

html的ajax请求:

<button id="up">下载文件</button>  一个按钮

请求：

// 下载文件

    $("#up").on("click", function () {

        $.ajax({

            url: "down/",

            type: "get",

            data: {},

            success: function (data) {

                var $a = $('<a></a>');

                $a.attr("href", "http://127.0.0.1:8000/down/");  # 红色的是你下载路径

                $("body").append($a);

                $a[0].click();

                $a.remove();

            }

        })