vue导出excle文件(后端接口传文件流)

后端接口返回的文件流:
在这里插入图片描述
定义:

此为https.js文件
// Excel文件下载
export function getExcelDownload(url, params) {
  return request({
    url: url,
    params,
    headers: {
      'Content-Type': 'application/json; application/octet-stream',
    },
    responseType: 'blob',
    method: 'get',
  })
    .then((response) => {
      const blob = new Blob([response.data], { type: 'application/vnd.ms-excel' })
      const url = window.URL.createObjectURL(blob)
      const link = document.createElement('a') // 创建a标签
      link.href = url
      link.download = params.fileName
      document.body.appendChild(link)
      link.click() // 执行下载
      document.body.removeChild(link) // 释放标签
    })
    .catch((error) => {
      console.log('下载excelerror', error)
    })
}

引入:

此为logistics文件
import { getExcelDownload } from '@/utils/https.js'

export const getPackInfoExport = (params) => {
  return getExcelDownload('/PackInfo/exportPost', params)
}

导入:

import {getPackInfoExport} from '@/api/logistics'

使用:

getPackInfoExport(exportParams).then((response) => {
   console.log('response:', response)
})

type:'application/zip’可以更改下载文件的类型,有以下这些类型

‘doc’ => ‘application/msword’,
‘bin’ => ‘application/octet-stream’,
‘exe’ => ‘application/octet-stream’,
‘so’ => ‘application/octet-stream’,
‘dll’ => ‘application/octet-stream’,
‘pdf’ => ‘application/pdf’,
‘ai’ => ‘application/postscript’,
‘xls’ => ‘application/vnd.ms-excel’,
‘ppt’ => ‘application/vnd.ms-powerpoint’,
‘dir’ => ‘application/x-director’,
‘js’ => ‘application/x-javascript’,
‘swf’ => ‘application/x-shockwave-flash’,
‘xhtml’ => ‘application/xhtml+xml’,
‘xht’ => ‘application/xhtml+xml’,
‘zip’ => ‘application/zip’,
‘mid’ => ‘audio/midi’,
‘midi’ => ‘audio/midi’,
‘mp3’ => ‘audio/mpeg’,
‘rm’ => ‘audio/x-pn-realaudio’,
‘rpm’ => ‘audio/x-pn-realaudio-plugin’,
‘wav’ => ‘audio/x-wav’,
‘bmp’ => ‘image/bmp’,
‘gif’ => ‘image/gif’,
‘jpeg’ => ‘image/jpeg’,
‘jpg’ => ‘image/jpeg’,
‘png’ => ‘image/png’,
‘css’ => ‘text/css’,
‘html’ => ‘text/html’,
‘htm’ => ‘text/html’,
‘txt’ => ‘text/plain’,
‘xsl’ => ‘text/xml’,
‘xml’ => ‘text/xml’,
‘mpeg’ => ‘video/mpeg’,
‘mpg’ => ‘video/mpeg’,
‘avi’ => ‘video/x-msvideo’,
‘movie’ => ‘video/x-sgi-movie’,

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值