下载Excel表格封装组件

import {api} from '@/axios'
import {Message} from 'element-ui'
import store from '@/store/index.ts'// obj 传参数据 URL 路径  token token downLoadTitle 文件名
export function download(obj: any, url:string, token:string,downLoadTitle: string) {api.get(url,{params:obj,responseType: 'blob',header: {'Authorization':token}}).then((res: any) => {if(res.data.type === 'application/json') {api.get(url,{params:obj}).then((ret: any) =>{//给用户不同的错误的提示Message.warning(ret.data.data)})}else{let blob = new Blob([res.data],{type:'application/vnd.ms-excel;charset=utf-8'});//创建一个新的blob对象if(res.headers['refreshtoken']){store.commit('refreshToken','Bearer' + res.headers['refreshtoken'])}if('download' in document.createElement('a')) {//if 条件是判断浏览器是否兼容a标签的download属性const downloadElement: any = document.createElement('a')继续;//创建a标签downloadElement.download = `${downLoadTitle}`.xlsx;//让浏览器下载URL而不是跳转到URL所指向的内容downloadElement.style.display = 'none';// 标签设置隐藏属性downloadElement.href = URL.createObjectURL(blob);//这个超链接指向的URL地址 => 创建URL对象document.body.appendChild(downloadElement);//挂载在body上downloadElement.click();//a标签点击行为  模拟文件下载(window.URL as any).revokeObjectURL(downloadElement.href);//释放创建的URL对象，让浏览器知道不用在内存中继续保留对这个文件的引用document.body.removeChild(downloadElement);//移除标签}else {navigator.msSaveBlob(blob,`${downLoadTitle}`.xlsx)}}})}
export default downLoad