导出excel表格组件及流程

excel导出组件、使用流程

1、在/utils/request文件夹中写入一下内容

组件一：
export function downloadPost(url, params, filename, timeOut) {
  downloadLoadingInstance = Loading.service({ text: "正在下载数据，请稍候", spinner: "el-icon-loading", background: "rgba(0, 0, 0, 0.7)", })
  return service.post(url, params, {
    responseType: 'blob',
    timeout: timeOut || 30000
  }).then(async (data) => {
    const isLogin = await blobValidate(data);
    if (isLogin) {
      const blob = new Blob([data])
      saveAs(blob, filename)
    } else {
      const resText = await data.text();
      const rspObj = JSON.parse(resText);
      const errMsg = errorCode[rspObj.code] || rspObj.msg || errorCode['default']
      Message.error(errMsg);
    }
    downloadLoadingInstance.close();
  }).catch((r) => {
    console.error(r)
    Message.error('下载文件出现错误，请联系管理员！')
    downloadLoadingInstance.close();
  })
}


组件二：
export function download(url, params, filename) {
  downloadLoadingInstance = Loading.service({
    text: '正在下载数据，请稍候',
    spinner: 'el-icon-loading',
    background: 'rgba(0, 0, 0, 0.7)'
  })
  return service.post(url, params, {
    transformRequest: [(params) => {
      return tansParams(params)
    }],
    headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
    responseType: 'blob'
  }).then(async(data) => {
    const isLogin = await blobValidate(data)
    if (isLogin) {
      const blob = new Blob([data])
      saveAs(blob, filename)
    } else {
      const resText = await data.text()
      const rspObj = JSON.parse(resText)
      const errMsg = errorCode[rspObj.code] || rspObj.msg || errorCode['default']
      Message.error(errMsg)
    }
    downloadLoadingInstance.close()
  }).catch((r) => {
    console.error(r)
    Message.error('下载文件出现错误，请联系管理员！')
    downloadLoadingInstance.close()
  })
}

2、在main.js中导入，并挂载到原型上，这样全局都可以使用

组件一：
import { downloadPost } from '@/utils/request'
Vue.prototype.downloadPost = downloadPost

组件二：
import { download } from '@/utils/request'
Vue.prototype.download = download

3、在代码中使用

    ①：写一个按钮添加点击事件，事件名以handleExport为例
    ②：在methods中写一个函数
        handleExport() {
				this.download('后端返回的接口',
                {...this.queryParams}, `文件名_${new Date().getTime()}.xlsx`)
			}
注：{...this.queryParams}为接口需要传的参数