https://www.npmjs.com/package/js-export-excel
第一步，先安装该组件：
npm install js
-export-excel
or
yarn add js
-export-excel
第二步，在需要地方引用
const ExportJsonExcel
= require("js-export-excel");
or
import ExportJsonExcel from
"js-export-excel";
开始使用
<template>
<div
class="about">
<button @click
="exportExcel">点击导出
</button
>
</div
>
</template>
<script
>
import ExportJsonExcel from
"js-export-excel";
export default {
data(){
return{
selections
:[
{'index':'0',"num": "001", "name": "小明"},
{'index':'1',"num": "002", "name": "小红"},
{'index':'2',"num": "003", "name": "小兰"}
]
}
},
methods
: {
exportExcel
: function
() {
var data
= this.selections
;
let dataTable
= [];
if (data
&& data
.length
> 0) {
for (let i in data
) {
if (data
[i
]) {
let obj
= {
索引
: data
[i
].index
,
学号
: data
[i
].num
,
姓名
: data
[i
].name
};
dataTable
.push(obj
);
}
}
this.exportToExcel(dataTable
);
}
},
exportToExcel
(dataTable
) {
var option
= {};
option
.fileName
= "学生信息";
option
.datas
= [
{
sheetData
: dataTable
,
sheetName
: "sheet",
sheetFilter
: [
"索引",
"学号",
"姓名"
],
sheetHeader
: [
"索引",
"学号",
"姓名"
]
}
];
var toExcel
= new ExportJsonExcel(option
);
toExcel
.saveExcel();
}
}
}
</script
>
<style scoped
>
</style
>
