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数据如下: