npm install qs

/**
 * 這里是ajax的通用訪問接口處理
 */
import axios from 'axios';
import Qs from 'qs';
import Message from './msgbox'; //封裝的message消息組件

const showMessage = (message, type = 'error') => {
  Message({
    type: 'error',
    message: message
  });
};

export default {
  /**
   * 封裝導(dǎo)出Excel文件post請求
   * @param url  下載接口url
   * @param data 參數(shù)
   * @returns {Promise}
   */
  download(url, options = {}) {
    this.filterEmptyKey(options, false);
    return new Promise((resolve, reject) => {
      axios.defaults.headers['Content-Type'] = 'application/json;charset=UTF-8';
      axios({
        method: 'post',
        url: url, // 請求地址
        data: options, // 參數(shù)
        responseType: 'blob' // 表明返回服務(wù)器返回的數(shù)據(jù)類型
      }).then(
        response => {
          let blob = new Blob([response.data], {
            type: 'application/vnd.ms-excel'
          });
          //判斷類型是否返回json圃庭，返回json時報(bào)錯
          if (response.data.type !== 'application/vnd.ms-excel') {
            let reader = new FileReader();
            reader.onload = e => {
              let result = JSON.parse(e.target.result);
              if (result) {
                showMessage(result.errorMessage);
                return reject(result);
              }
            };
            reader.readAsText(blob);
          } else {
            resolve(response.data);
            let now = new Date();
            let fileName = now.getTime() + '.xlsx';
            if (window.navigator.msSaveOrOpenBlob) {
              navigator.msSaveBlob(blob, fileName);
            } else {
              let link = document.createElement('a');
              link.href = window.URL.createObjectURL(blob);
              link.download = fileName;
              link.click();
              //釋放內(nèi)存
              window.URL.revokeObjectURL(link.href);
            }
          }
        },
        err => {
          reject(err);
        }
      );
    });
  },

  /**
   * 服務(wù)端接口empty字符串跟null返回的結(jié)果不同，過濾掉empty字符串
   * @param params
   * @param emptyString 是否過濾空字符串
   */
  filterEmptyKey(params, emptyString) {
    Object.keys(params).forEach(key => {
      if (params[key] === null || (emptyString && params[key] === '')) {
        delete params[key];
      }
    });
  },

  /**
   * 封裝導(dǎo)出Excal文件get請求
   * @param url  下載接口url
   * @param data 參數(shù)
   * @returns {Promise}
   */
  getDownload(url, options = {}) {
    this.filterEmptyKey(options, true);
    options = Qs.stringify(options, { arrayFormat: 'repeat' });
    return new Promise((resolve, reject) => {
      axios.defaults.headers['Content-Type'] = 'application/json;charset=UTF-8';
      axios({
        method: 'get',
        url: url + '?' + options, // 請求地址
        responseType: 'blob' // 表明返回服務(wù)器返回的數(shù)據(jù)類型
      }).then(
        response => {
          let blob = new Blob([response.data], {
            type: 'application/vnd.ms-excel'
          });
          //判斷類型是否返回json失晴，返回json時報(bào)錯
          if (response.data.type !== 'application/vnd.ms-excel') {
            let reader = new FileReader();
            reader.onload = e => {
              let result = JSON.parse(e.target.result);
              if (result) {
                showMessage(result.errorMessage);
                return reject(result);
              }
            };
            reader.readAsText(blob);
          } else {
            //正確時導(dǎo)出文件
            resolve(response.data);
            let now = new Date();
            let fileName = now.getTime() + '.xlsx';
            if (window.navigator.msSaveOrOpenBlob) {
              navigator.msSaveBlob(blob, fileName);
            } else {
              let link = document.createElement('a');
              link.href = window.URL.createObjectURL(blob);
              link.download = fileName;
              link.click();
              //釋放內(nèi)存
              window.URL.revokeObjectURL(link.href);
            }
          }
        },
        err => {
          reject(err);
        }
      );
    });
  }
};

//使用
exportExcel
        .download(api地址, 穿參數(shù)(post))
        .then(res => {
          this.$message({
            message: '導(dǎo)出成功剧腻，正在下載',
            type: 'success'
          });
        })