elementUI +vue 导出二进制文件流excel文件

1.html代码

  <el-button  icon="el-icon-download" size="small"
            type="primary" plain @click="exportExcel()">导出</el-button>

2.js代码

  //导出 exportExcel
    exportExcel() {
      const paralist = {
        month: this.listQuery.month,
      };
      const _that = this;
      // 导出所有数据
      this.$confirm("是否确认导出数据?", "警告", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      }).then(function () {
        _that.fullscreenLoading = true;
//exportExcel 连接后台数据方法
        exportExcel(paralist).then((response) => {
          const blob = new Blob([response], { type: "application/xlsx" });
          const filename = "绩效.xlsx";
          const link = document.createElement("a");
          console.log(link);
          link.href = URL.createObjectURL(blob);
          link.download = filename;
          console.log(link);
          document.body.appendChild(link);
          link.click();
          window.setTimeout(function () {
            URL.revokeObjectURL(blob);
            document.body.removeChild(link);
            _that.fullscreenLoading = false;
          }, 0);
        });
      });
    },

3.获取后台数据方法 exportExcel 

import request from '@/utils/request'


export function exportExcel(query) {
  return request({
    url: '/internal/pactdetail/export',
    method: 'get',
    params: query,
    //这句必须加上
    responseType: 'arraybuffer'
  })
}

4.request。js文件

import axios from 'axios'
import qs from 'qs'
import {
  MessageBox,
  Message
} from 'element-ui'
import store from '@/store'
import {
  getToken
} from '@/utils/auth'

// create an axios instance
const service = axios.create({
  baseURL: process.env.VUE_APP_BASE_API, // url = base url + request url
  // withCredentials: true, // send cookies when cross-domain requests
  timeout: 50000 // request timeout
})

// request interceptor
service.interceptors.request.use(
  config => {
    // do something before request is sent
    if (store.getters.token) {
      // let each request carry token
      // ['X-Token'] is a custom headers key
      // please modify it according to the actual situation
      config.headers['Authorization'] = getToken()
    }
    // 可以传入数组
    if (config.method === 'get') {
      config.paramsSerializer = function(params) {
        return qs.stringify(params, {
          arrayFormat: 'repeat'
        })
      }
    }
    return config
  },
  error => {
    // do something with request error
    console.log(error) // for debug
    return Promise.reject(error)
  }
)

// response interceptor
service.interceptors.response.use(
  /**
   * If you want to get http information such as headers or status
   * Please return  response => response
   */

  /**
   * Determine the request status by custom code
   * Here is just an example
   * You can also judge the status by HTTP Status Code
   */
  response => {
    const res = response.data
    const status = Number(response.status) || 200
    // if the custom code is not 20000, it is judged as an error.
    if (status !== 200 || res.code === 1) {
      Message({
        message: res.msg || 'Error',
        type: 'error',
        duration: 5 * 1000
      })

      // 50008: Illegal token; 50012: Other clients logged in; 50014: Token expired;
      if (status === 401 || status === 403) {
        // to re-login
        MessageBox.confirm('You have been logged out, you can cancel to stay on this page, or log in again', 'Confirm logout', {
          confirmButtonText: '重新登录',
          cancelButtonText: '取消',
          type: 'warning'
        }).then(() => {
          store.dispatch('user/resetToken').then(() => {
            location.reload()
          })
        })
      }
      return Promise.reject(new Error(res.message || 'Error'))
    } else {
      return res
    }
  },
  error => {
    console.log('err' + error) // for debug
    Message({
      message: error.message,
      type: 'error',
      duration: 5 * 1000
    })
    return Promise.reject(error)
  }
)

export default service