Elementui exports data to xlsx and excel tables

npm install file-saver
npm install xlsx

//Export excel table template in vue import FileSaver from 'file-saver'
import XLSX from 'xlsx'
 
Vue.prototype.$FileSaver = FileSaver; //Set global Vue.prototype.$XLSX = XLSX; //Set global

<template>
  <div class="daochu">
      <el-button @click="o" type="success" round>Export</el-button>
      <el-table
    id="ou"
    :data="tableData"
    style="width: 100%"
    :default-sort="{ prop: 'date', order: 'descending' }"
     >
    <el-table-column prop="date" label="Date" sortable width="180">
    </el-table-column>
    <el-table-column prop="name" label="Name" sortable width="180">
    </el-table-column>
    <el-table-column prop="address" label="Address" :formatter="formatter">
    </el-table-column>
  </el-table>
 
  </div>
</template>
<script>
export default {
  data() {
    return {
      tableData: [
        {
          date: "2016-05-02",
          name: "Wang Xiaohu",
          address: "No. 1518, Jinshajiang Road, Putuo District, Shanghai",
        },
        {
          date: "2016-05-04",
          name: "Wang Xiaohu",
          address: "No. 1517, Jinshajiang Road, Putuo District, Shanghai",
        }
      ],
    };
  },
  methods:{
    o() {
      let tables = document.getElementById("ou");
      let table_book = this.$XLSX.utils.table_to_book(tables);
      var table_write = this.$XLSX.write(table_book, {
        bookType: "xlsx",
        bookSST: true,
        type: "array",
      });
      try {
        this.$FileSaver.saveAs(
          new Blob([table_write], { type: "application/octet-stream" }),
          "sheetjs.xlsx"
        );
      } catch (e) {
        if (typeof console !== "undefined") console.log(e, table_write);
      }
      return table_write;
    },
  }
}
</script>