vxe-table-plugin-export-xlsx

基于 vxe-table 表格的增强插件，支持导出 xlsx 格式

Installing

1npm install xe-utils vxe-table vxe-table-plugin-export-xlsx xlsx

1import Vue from 'vue'
2import VXETable from 'vxe-table'
3import VXETablePluginExportXLSX from 'vxe-table-plugin-export-xlsx'
4
5Vue.use(VXETable)
6VXETable.use(VXETablePluginExportXLSX)

Demo

1<vxe-toolbar>
2  <template v-slot:buttons>
3    <vxe-button @click="exportEvent">导出.xlsx</vxe-button>
4  </template>
5</vxe-toolbar>
6
7<vxe-table
8  border
9  ref="xTable"
10  height="600"
11  :data="tableData">
12  <vxe-table-column type="index" width="60"></vxe-table-column>
13  <vxe-table-column prop="name" label="Name"></vxe-table-column>
14  <vxe-table-column prop="age" label="Age"></vxe-table-column>
15  <vxe-table-column prop="date" label="Date"></vxe-table-column>
16</vxe-table>

1export default {
2  data () {
3    return {
4      tableData: [
5        {
6          id: 100,
7          name: 'test',
8          age: 26,
9          date: null
10        }
11      ]
12    }
13  },
14  methods: {
15    exportEvent() {
16      this.$refs.exportData({
17        filename: 'export',
18        sheetName: 'Sheet1',
19        type: 'xlsx'
20      })
21    }
22  }
23}

License

MIT License, 2019-present, Xu Liangzhan