vue二进制流文件下载Excel

姜来前端程序媛

于 2024-05-23 10:56:55 发布

阅读量204

点赞数 1

文章标签： vue.js excel 前端

本文链接：https://blog.csdn.net/weixin_74285634/article/details/139141888

版权

const windowOpen = () => {
  axios({ // 用axios发送get请求
      method: 'get',
      url:import.meta.env.VITE_API_URL + '/system/user/downloadExcelTemplateForTeacher', // 请求地址
      headers: {
        'Authorization': userInfoStore.token
      }
    }).then(res => { // 处理返回的文件流
      const fileUrl = res.request.responseURL;
      axios.get(fileUrl, {
                    responseType: "blob",
                    headers: {
                        Authorization: userInfoStore.token,
                    },
                })
                .then((response) => {
                    const blob = new Blob([response.data], {
                        type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' // 设置Excel文件类型
                    });
                    const url = URL.createObjectURL(blob);
                    const link = document.createElement('a');
                    link.href = url;
                    link.download = "示例文件.xlsx"; // 设置下载文件的名称为.xlsx格式
                    document.body.appendChild(link);
                    link.click();
                    document.body.removeChild(link);
                });
    })
}

文件上传后缀名与文件类型对照表

1、xls
application/vnd.ms-excel
2、xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
3、ppt
application/vnd.ms-powerpoint
4、pptx
application/vnd.openxmlformats-officedocument.presentationml.presentation
5、doc
application/msword
6、docx
application/vnd.openxmlformats-officedocument.wordprocessingml.document
7、zip
application/x-zip-compressed
8、rar
application/x-zip-compressed
9、wmv
video/x-ms-wmv
10、mp3
audio/mpeg
11、mp4
video/mp4
12、gif
image/gif
13、jpg
image/jpeg
14、png
image/png
15、bmp
image/bmp
16、psd
application/octet-stream
17、ico
image/x-icon
18、7z
application/octet-stream
19、exe
application/octet-stream
20、avi
video/avi
21、rmvb
application/vnd.rn-realmedia-vbr
22、3gp
application/octet-stream
23、flv
application/octet-stream
24、wav
audio/wav
25、krc
application/octet-stream
26、lrc
application/octet-stream
27、txt
text/plain
28、pdf
application/pdf
29、chm
application/octet-stream
30、mdb
application/msaccess
31、sql
application/octet-stream
32、con
application/octet-stream
33、log
text/plain
34、dat
application/octet-stream
35、ini
application/octet-stream
36、php
application/octet-stream
37、html 和 htmhtm
text/html
38、ttf
application/octet-stream
39、fon
application/octet-stream
40、js
application/x-javascript
41、xml
text/xml
42、dll
application/octet-stream