Blame view

src/views/demo/excel/CustomExport.vue 1.26 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="openModal"> 导出 </a-button>
jq authored
6
7
      </template>
    </BasicTable>
8
    <ExpExcelModal @register="register" @success="defaultHeader" />
9
  </PageWrapper>
jq authored
10
11
12
13
14
</template>

<script lang="ts">
  import { defineComponent } from 'vue';
  import { BasicTable } from '/@/components/Table';
15
  import { jsonToSheetXlsx, ExpExcelModal, ExportModalResult } from '/@/components/Excel';
jq authored
16
17
  import { columns, data } from './data';
  import { useModal } from '/@/components/Modal';
18
  import { PageWrapper } from '/@/components/Page';
jq authored
19
20

  export default defineComponent({
21
    components: { BasicTable, ExpExcelModal, PageWrapper },
jq authored
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
    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>