vue中Excel导出

<Button class="mr10" type="primary" @click="exportSampleStockExcel()" :disabled="exportSampleStockExcel">导出</Button>

 

 

 exportSampleStockExcel(){

        let brandId=localStorage.brandId  //是否为品牌款

      let qyType=localStorage.qyType //企业类型

        this.$axios({

          url:'/sampleStock/exportSampleStockExcel',

          method:'get',

          responseType:'blob',

          // data:{this.pageParam, this.searchData}

          params: {

          pageNum: this.pageParam.pageNum,

          pageSize: this.pageParam.pageSize,

          stockArea:this.searchData.stockArea,

          styleDipartite: this.searchData.styleDipartite,

          styleSource: this.searchData? this.searchData.styleSource: '',

          holderBy: this.searchData.holderBy,

          holderDataType: this.searchData.holderDataType,

          updateDateStart: this.searchData&&this.searchData.updateDate[0]? $helper.formatTime(Date.parse(new Date(searchData.updateDate[0]))) : '',

          updateDateEnd: this.searchData&&this.searchData.updateDate[1]? $helper.formatTime(Date.parse(new Date(searchData.updateDate[1])), 'Y-M-D')+' 23:59:59' : '',

          brandId:brandId=='undefined'?null:brandId,

          sampleDressCode: this.searchData.sampleDressCode,

          // 样衣列表不传，选款列表传。(是否是企业)

          brandDataType:brandId=='undefined'?null:(qyType === 'qy' ? 1 : 2),

          inventoryClassId: this.searchData.inventoryClassId,

          isBarcodePrint: this.searchData.isBarcodePrint,

          channelSource:this.searchData.channelSource,

          operation: this.searchData.operation,

        }

        }).then((data)=>{

          const url = window.URL.createObjectURL(data.data)

          const a = document.createElement('a')

          a.href = url

          a.download = '样衣列表.xls'

          document.body.appendChild(a)

          a.click()

          window.URL.revokeObjectURL(url)

          document.body.removeChild(a)

        }).catch(err => {

        reject('接口请求错误')

      })

      }

转载于:https://www.cnblogs.com/wssdx/p/11481767.html