使用element-ui 实现excel表格导出

  <template slot="menuLeft" >
          <el-button type="primary" icon="el-icon-plus" size="small"
          	    @click="DownloadExcel" >导出表格
          </el-button>
       </template>
     </avue-crud>

// await listAll()  listall()是调用当前所有的接口

   // 导出表格
       async DownloadExcel(){
         let listData = await listAll()
         listData = listData.data.data
         let dataList = []
         dataList.push(new Array(this.option.column.length))
         for (let i = 0; i < this.option.column.length; i++) {
           dataList[0][i] = this.option.column[i].label;
         }
         for (var i = 0; i < listData.length; i++) {
           dataList.push(new Array(this.option.column.length))
           for (var j = 0; j < this.option.column.length; j++) {
            dataList[i+1][j] = listData[i][this.option.column[j].prop]
           }
         }
         // 初始化
         var workbook = XLSX.utils.book_new();
         // 数据
         var ws1 = XLSX.utils.aoa_to_sheet(dataList)
         // 这是  Sheet
         XLSX.utils.book_append_sheet(workbook, ws1, "Sheet1");
         XLSX.writeFile(workbook, 'table.xlsx');
       },