vue elementui 导出excel

最新推荐文章于 2024-10-14 13:22:38 发布

木毅01

最新推荐文章于 2024-10-14 13:22:38 发布

阅读量108

点赞数 1

分类专栏： vue elementui 文章标签： vue.js elementui excel

本文链接：https://blog.csdn.net/qq_27806371/article/details/141032036

版权

vue 同时被 2 个专栏收录

38 篇文章 0 订阅

订阅专栏

elementui

10 篇文章 0 订阅

订阅专栏

    <el-table
        v-loading="loading"
        element-loading-text="数据加载中"
        :data="menuList.records"
        row-key="id"
        ref="dataTable"
      >
      ...
    </el-table>   

    tiktokexportpageHandle(){
      this.loading=true;
      let startTime = "";
      let endTime = "";
      if (this.dates == null) {
        startTime = "";
        endTime = "";
      } else {
        startTime = new Date(this.dates[0]).getTime() ;
        endTime = new Date(this.dates[1]).getTime();
      }
      tiktokexportxxxxxx({//接口名称
        accountId: this.serchFormf.searchID,
        accountName: this.serchFormf.searchName,
        company: this.serchFormf.company,
        status:this.serchFormf.status,
        st: startTime,
        et: endTime,
      }).then((res) => {
        // 从response的headers中获取filename, 后端response.setHeader("Content-disposition", "attachment; filename=xxxx.docx") 设置的文件名;
        let patt = /filename=(\S*)/
        let contentDisposition = decodeURI(res.headers['content-disposition'])
        let result = contentDisposition.match(patt)
        let fileName = result[1]
        let blob = new Blob([res.data])
        let reader = new FileReader()
        reader.readAsDataURL(blob) // onload当读取操作成功完成时调用
        reader.onload = (e) => {
          let aElement = document.createElement('a')
          aElement.setAttribute('download', fileName)
          aElement.href = e.target.result // 赋予文件下载地址
          document.body.appendChild(aElement) // a标签插至页面中
          aElement.click()
          document.body.removeChild(aElement)
          this.loading = false;
        }
      }).catch((error) => {
        this.loading = false;
      });
    },