1.下载element ui
yarn add element-ui -S
2.下载excel插件
yarn add vue-json-excel
3.在main.js中引用
import JsonExcel from 'vue-json-excel'
Vue.component('downloadExcel', JsonExcel)
4.导出按钮
<download-excel
class="export-excel-wrapper"
:data="devicedetailData"
:fields="json_fields"
name="设备信息列表.xls"
>
<el-button style="margin-right:10px;">导出</el-button>
</download-excel>
5.data格式
json_fields: {
"姓名": "name", //常规字段
"用户名":"username",
"所属组织":"organization",
"权限":"auth",
},
tableData: [
//写死,后续可通过接口进行传值
{
name:'汤姆',
username:'admin1',
organization:'地球村',
auth:'超级管理员'
},
{
name:'杰米',
username:'admin2',
organization:'地球村',
auth:'超级管理员'
}
],
json_meta: [
[
{
" key ": " charset ",
" value ": " utf- 8 "
}
]
]
以上是参考网上的博客,有什么问题还请大家多多指教~