vue+django下载文档

vue+Django实现excel文件下载

vue端

<template>
    <div id="home">
        <a :href="'http://localhost:8000/download/?way_id=' + id"> 下载记录</div>
</template>


<script>
    export default {
        name: 'home',
        data() {
            return {
                id: '',
            }
        },    
    }
</script>

django端

# 下载记录
class Downloadrecord(View):

    def get(self,request):
        #获取数据
        way_id = request.GET.get('way_id')
        #从数据库里找到网excel写入的数据
        waybill_Form_class = Waybill_Form.objects.get(id=way_id)
        waybill_temperature_all = waybill_Form_class.temperature_all
        waybill_temperature_all = eval(waybill_temperature_all)
		
        #excel写入
        #写入标题
        with open('data.csv','w',encoding='gbk') as csvf:
            writer = csv.writer(csvf,delimiter=',')
            writer.writerow(['时间','温度'])
		#写入内容
        for i in waybill_temperature_all:
            time = i['time']
            temp = i['temp']
            with open('data.csv','a',encoding='gbk') as csvf:
                writer = csv.writer(csvf,delimiter=',')
                writer.writerow([time,temp])
        #把excel返回给前端
        file_path = 'data.csv'
        with open(file_path, "rb") as f:
            res = HttpResponse(f)
            res["Content-Type"] = "application/octet-stream" #  注意格式
            res["Content-Disposition"] = 'filename="{}"'.format(file_path)
        return res

到此ok完工