vue 导入导出功能 方式1

封装的axios请求

const axiosInstance = axios.create({
    baseURL: window.g.URL,
    responseType: 'json',
    timeout: 50000
});
export function fetch(url, params,type){
    let promise  = new Promise((resolve, reject) => {
        axiosInstance({
            method: 'post',
            url,
            data: params,
            responseType: type?'blob':'json',
        }).then(res => {
            resolve(res)
        }).catch(err => {
            reject(err)
        })
    })
}

导出/下载

export function RecodExportTemp(params,type){
  return fetch('/abtclock/kqrecord/export',params,type);
}

 download(){
      let data = {comid:this.comid}
        //使用封装的axios请求
        RecodExportTemp(data,{responseType: 'arraybuffer'}).then(res=>{
        let aTag = document.createElement('a');
        let blob = new Blob([res.data],{
          type: "application/vnd.ms-excel",
        });　
        aTag.download = '考勤记录.xls';　　　　
        aTag.href = URL.createObjectURL(blob);
        aTag.click();　　　　　　　　　　　　　　
        URL.revokeObjectURL(blob);
      }).catch(err=>{})
    },

导入 

export function UsersImport(params){
  return fetchFile('/abtclock/employee/employeeImport',params);
}

importFile(e) {
      let _this = this;
      let data = new FormData();
      data.append("file", e.target.files[0]);
      data.append("comid", this.comid);
      let name = e.target.files[0].name;
      let n1 = name.substring(name.lastIndexOf(".") + 1);
      this.$refs['file'].value = ''
      if (n1 != "xls"&&n1 != "xlsx") {
          this.$message({
          message: "请上传Excel文件！！！",
          type: "error"
          });
          return false;
      }
    //axios请求接口
      UsersImport(data).then(res=>{
        _this.$message({
            type:'success',
            message:'导入成功！'
          })
          _this.getlist()
        // _this.credentialVisible = false
      }).catch(err=>{

      })
    },