【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(); } })
版权声明:本文为wanghong1994原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。