Vue+File saver+xlsx使用aoa_to_sheet导出数据为excel

aoa_to_sheet是将数组类型的数据导出到excel。

1.js代码如下：

<script>
import { saveAs } from "file-saver";
import XLSX from "xlsx";
export default {
  name: "TableColumnShowHideDemo",
  data() {
    return {
      exportArrayData: [
        ["序号", "英文名", "中文名"],
        ["1", "Good Morning", "早上好"],
        ["2", "Good Morning", "早上好"],
        ["3", "Good Morning", "早上好"],
        ["4", "Good Morning", "早上好"],
        ["5", "Good Morning", "早上好"]
      ]
    };
  },
  methods: {
    downloadData: function() {
      this.exportArrayDataToExcel();
    },
    exportArrayDataToExcel: function() {
      var ws = XLSX.utils.aoa_to_sheet(this.exportArrayData);

      var wb = XLSX.utils.book_new();
      XLSX.utils.book_append_sheet(wb, ws, "exportArrayDataToExcel");

      /* 保存至文件 */
      XLSX.writeFile(wb, "exportArrayDataToExcel.xlsx");
    }
  }
};

2.html代码如下：

<template>
  <div>
    <el-button type="" @click="downloadData()">下载</el-button>
  </div>
</template>

3.页面格式：

4.下载Excel数据如下：