Blame view

src/views/demo/excel/ArrayExport.vue 1.01 KB
jq authored
1
<template>
2
  <PageWrapper title="导出示例" content="根据数组格式的数据进行导出">
jq authored
3
4
    <BasicTable title="基础表格" :columns="columns" :dataSource="data">
      <template #toolbar>
5
        <a-button @click="aoaToExcel"> 导出 </a-button>
jq authored
6
7
      </template>
    </BasicTable>
8
  </PageWrapper>
jq authored
9
10
11
12
13
</template>

<script lang="ts">
  import { defineComponent } from 'vue';
  import { BasicTable } from '/@/components/Table';
vben authored
14
  import { aoaToSheetXlsx } from '/@/components/Excel';
jq authored
15
  import { arrHeader, arrData, columns, data } from './data';
16
  import { PageWrapper } from '/@/components/Page';
jq authored
17
18

  export default defineComponent({
19
    components: { BasicTable, PageWrapper },
jq authored
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
    setup() {
      function aoaToExcel() {
        // 保证data顺序与header一致
        aoaToSheetXlsx({
          data: arrData,
          header: arrHeader,
          filename: '二维数组方式导出excel.xlsx',
        });
      }

      return {
        aoaToExcel,
        columns,
        data,
      };
    },
  });
</script>