下载Excel表格

下载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