| 提交 | 用户 | age | ||
| a207ca | 1 | <template> |
| 31ff05 | 2 | <PageWrapper title="导出示例" content="根据数组格式的数据进行导出"> |
| a207ca | 3 | <BasicTable title="基础表格" :columns="columns" :dataSource="data"> |
| J | 4 | <template #toolbar> |
| 5 | <a-button @click="aoaToExcel">导出</a-button> | |
| 6 | </template> | |
| 7 | </BasicTable> | |
| 31ff05 | 8 | </PageWrapper> |
| a207ca | 9 | </template> |
| J | 10 | |
| 11 | <script lang="ts"> | |
| 12 | import { defineComponent } from 'vue'; | |
| 13 | import { BasicTable } from '/@/components/Table'; | |
| 29461a | 14 | import { aoaToSheetXlsx } from '/@/components/Excel'; |
| a207ca | 15 | import { arrHeader, arrData, columns, data } from './data'; |
| 31ff05 | 16 | import { PageWrapper } from '/@/components/Page'; |
| a207ca | 17 | |
| J | 18 | export default defineComponent({ |
| 31ff05 | 19 | components: { BasicTable, PageWrapper }, |
| a207ca | 20 | setup() { |
| J | 21 | function aoaToExcel() { |
| 22 | // 保证data顺序与header一致 | |
| 23 | aoaToSheetXlsx({ | |
| 24 | data: arrData, | |
| 25 | header: arrHeader, | |
| 26 | filename: '二维数组方式导出excel.xlsx', | |
| 27 | }); | |
| 28 | } | |
| 29 | ||
| 30 | return { | |
| 31 | aoaToExcel, | |
| 32 | columns, | |
| 33 | data, | |
| 34 | }; | |
| 35 | }, | |
| 36 | }); | |
| 37 | </script> | |
