当前位置 博文首页 > q1424966670的博客:vue导出Excel(二)
?下载Export2Excel、Blob等js文件????????提取码:s8ci
下面demo是把table的json数据导出为单个sheet的Excel,相对于上一篇文章,支持自定义列导出,不是把表格的列全部导出
<template>
<div>
<el-button type="primary" @click="export2Excel()">导出Excel</el-button>
</div>
</template>
<script>
export default {
components: {},
data() {
return {
tableData: [
{ index: 0, username: "张三", password: 333, age: 22 },
{ index: 1, username: "李四", password: 444, age: 23 },
],
};
},
methods: {
export2Excel() {
require.ensure([], () => {
const { export_json_to_excel } = require("@/excel/Export2Excel");
const fieldName = ["索引", "用户名", "密码"];
const filterVal = ["index", "username", "password"];
const data = this.tableData.map((v) => filterVal.map((j) => v[j]));
console.log(data);
export_json_to_excel(fieldName, data, "用户列表");
});
},
},
watch: {},
};
</script>
<style lang="scss" scoped>
</style>
cs