通过Export2Zip实现表格内容下载成为excel文件

代码如下

    // 下载
    handleDownload() {
      this.downloadLoading = true
      import('@/vendor/Export2Zip').then(zip => {
        const tHeader = ['Id', 'Title', 'Author', 'Readings', 'Date']
        const filterVal = ['id', 'title', 'author', 'pageviews', 'display_time']
        const list = this.list
        const data = this.formatJson(filterVal, list)

        // export_txt_to_zip(th, jsonData, txtName, zipName)
        zip.export_txt_to_zip(tHeader, data, this.filename, this.filename)
        this.downloadLoading = false
      })
    },

 

1.文件引入：@/vendor/Export2Zip

2.tHeader为txt文件的表头字段

3.相应字段通过如下的方法在所有数据list中获得(运用两个map方法)

    formatJson(filterVal, jsonData) {
      return jsonData.map(v => filterVal.map(j => v[j]))
    }