1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| <template>
| <PageWrapper title="导出示例" content="可以选择导出格式">
| <BasicTable title="基础表格" :columns="columns" :dataSource="data">
| <template #toolbar>
| <a-button @click="openModal">导出</a-button>
| </template>
| </BasicTable>
| <ExpExcelModel @register="register" @success="defaultHeader" />
| </PageWrapper>
| </template>
|
| <script lang="ts">
| import { defineComponent } from 'vue';
| import { BasicTable } from '/@/components/Table';
| import { jsonToSheetXlsx, ExpExcelModel, ExportModalResult } from '/@/components/Excel';
| import { columns, data } from './data';
| import { useModal } from '/@/components/Modal';
| import { PageWrapper } from '/@/components/Page';
|
| export default defineComponent({
| components: { BasicTable, ExpExcelModel, PageWrapper },
| setup() {
| function defaultHeader({ filename, bookType }: ExportModalResult) {
| // 默认Object.keys(data[0])作为header
| jsonToSheetXlsx({
| data,
| filename,
| write2excelOpts: {
| bookType,
| },
| });
| }
| const [register, { openModal }] = useModal();
|
| return {
| defaultHeader,
| columns,
| data,
| register,
| openModal,
| };
| },
| });
| </script>
|
|
