ArrayExport.vue
1.67 KB
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
46
47
48
49
50
51
52
53
54
55
56
57
58
<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">
import { defineComponent } from 'vue';
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';
export default defineComponent({
components: { BasicTable, PageWrapper },
setup() {
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',
});
}
return {
aoaToExcel,
aoaToMultipleSheet,
columns,
data,
};
},
});
</script>