mirror of
https://gitee.com/x-extends/vxe-table-plugin-export-xlsx.git
synced 2026-01-21 05:21:33 +08:00
82 lines
2.2 KiB
Markdown
82 lines
2.2 KiB
Markdown
# vxe-table-plugin-export-xlsx
|
||
|
||
[](https://gitee.com/x-extends/vxe-table-plugin-export-xlsx/stargazers)
|
||
[](https://www.npmjs.com/package/vxe-table-plugin-export-xlsx)
|
||
[](http://npm-stat.com/charts.html?package=vxe-table-plugin-export-xlsx)
|
||
[](LICENSE)
|
||
|
||
基于 [vxe-table](https://www.npmjs.com/package/vxe-table) 的表格插件，支持导出 xlsx 格式，基于 [exceljs](https://github.com/exceljs/exceljs) 实现
|
||
|
||
## Compatibility
|
||
|
||
对应 vxe-table v3 版本
|
||
|
||
## Installing
|
||
|
||
```shell
|
||
npm install vxe-table@legacy vxe-table-plugin-export-xlsx@legacy exceljs
|
||
```
|
||
|
||
```javascript
|
||
// ...
|
||
import VXETable from 'vxe-table'
|
||
import VXETablePluginExportXLSX from 'vxe-table-plugin-export-xlsx'
|
||
import ExcelJS from 'exceljs'
|
||
// ...
|
||
|
||
// 方式1：NPM 安装，注入 ExcelJS 对象
|
||
VXETable.use(VXETablePluginExportXLSX, {
|
||
ExcelJS
|
||
})
|
||
|
||
// 方式2：CDN 安装，只要确保 window.ExcelJS 存在即可
|
||
// VXETable.use(VXETablePluginExportXLSX)
|
||
```
|
||
|
||
## Demo
|
||
|
||
```html
|
||
<vxe-toolbar>
|
||
<template v-slot:buttons>
|
||
<vxe-button @click="exportEvent">导出.xlsx</vxe-button>
|
||
</template>
|
||
</vxe-toolbar>
|
||
|
||
<vxe-table
|
||
ref="xTable"
|
||
height="600"
|
||
:data="tableData">
|
||
<vxe-column type="seq" width="60"></vxe-column>
|
||
<vxe-column field="name" title="Name"></vxe-column>
|
||
<vxe-column field="age" title="Age"></vxe-column>
|
||
<vxe-column field="date" title="Date"></vxe-column>
|
||
</vxe-table>
|
||
```
|
||
|
||
```javascript
|
||
export default {
|
||
data () {
|
||
return {
|
||
tableData: [
|
||
{ id: 100, name: 'test', age: 26, date: null },
|
||
{ id: 101, name: 'test1', age: 30, date: null },
|
||
{ id: 102, name: 'test2', age: 34, date: null }
|
||
]
|
||
}
|
||
},
|
||
methods: {
|
||
exportEvent() {
|
||
this.$refs.xTable.exportData({
|
||
filename: 'export',
|
||
sheetName: 'Sheet1',
|
||
type: 'xlsx'
|
||
})
|
||
}
|
||
}
|
||
}
|
||
```
|
||
|
||
## License
|
||
|
||
[MIT](LICENSE) © 2019-present, Xu Liangzhan
|