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
45
| <template>
| <PageWrapper title="导出示例" content="根据数组格式的数据进行导出">
| <BasicTable title="基础表格" :columns="columns" :dataSource="data">
| <template #toolbar>
| <a-button @click="aoaToExcel"> 导出 </a-button>
| <a-button @click="aoaToMultipleSheet" danger> 导出多Sheet </a-button>
| </template>
| </BasicTable>
| </PageWrapper>
| </template>
|
| <script lang="ts" setup>
| import { BasicTable } from '@/components/Table';
| import { aoaToSheetXlsx } from '@/components/Excel';
| import { arrHeader, arrData, columns, data } from './data';
| import { PageWrapper } from '@/components/Page';
| import { aoaToMultipleSheetXlsx } from '@/components/Excel/src/Export2Excel';
|
| function aoaToExcel() {
| // 保证data顺序与header一致
| aoaToSheetXlsx({
| data: arrData,
| header: arrHeader,
| filename: '二维数组方式导出excel.xlsx',
| });
| }
| function aoaToMultipleSheet() {
| // 保证data顺序与header一致
| aoaToMultipleSheetXlsx({
| sheetList: [
| {
| data: arrData,
| header: arrHeader,
| sheetName: 'Sheet1',
| },
| {
| data: arrData,
| header: arrHeader,
| sheetName: 'Sheet2',
| },
| ],
| filename: '二维数组方式导出excel-多Sheet示例.xlsx',
| });
| }
| </script>
|
|
