From bfdfeb40c7ba97511584a30477acf5ad801398ba Mon Sep 17 00:00:00 2001 From: YangYuGang <1378265336@qq.com> Date: 星期二, 11 三月 2025 11:26:34 +0800 Subject: [PATCH] 一些更改 --- src/views/demo/excel/JsonExport.vue | 105 +++++++++++++++++++++++----------------------------- 1 files changed, 46 insertions(+), 59 deletions(-) diff --git a/src/views/demo/excel/JsonExport.vue b/src/views/demo/excel/JsonExport.vue index d1789ea..af6ee09 100644 --- a/src/views/demo/excel/JsonExport.vue +++ b/src/views/demo/excel/JsonExport.vue @@ -10,27 +10,49 @@ </PageWrapper> </template> -<script lang="ts"> - import { defineComponent } from 'vue'; - import { BasicTable } from '/@/components/Table'; - import { jsonToSheetXlsx } from '/@/components/Excel'; +<script lang="ts" setup> + import { BasicTable } from '@/components/Table'; + import { jsonToSheetXlsx } from '@/components/Excel'; import { columns, data } from './data'; - import { PageWrapper } from '/@/components/Page'; - import { jsonToMultipleSheetXlsx } from '/@/components/Excel/src/Export2Excel'; + import { PageWrapper } from '@/components/Page'; + import { jsonToMultipleSheetXlsx } from '@/components/Excel/src/Export2Excel'; - export default defineComponent({ - components: { BasicTable, PageWrapper }, - setup() { - function defaultHeader() { - // 榛樿Object.keys(data[0])浣滀负header - jsonToSheetXlsx({ + function defaultHeader() { + // 榛樿Object.keys(data[0])浣滀负header + jsonToSheetXlsx({ + data, + filename: '浣跨敤key浣滀负榛樿澶撮儴.xlsx', + }); + } + + function customHeader() { + jsonToSheetXlsx({ + data, + header: { + id: 'ID', + name: '濮撳悕', + age: '骞撮緞', + no: '缂栧彿', + address: '鍦板潃', + beginTime: '寮�濮嬫椂闂�', + endTime: '缁撴潫鏃堕棿', + }, + filename: '鑷畾涔夊ご閮�.xlsx', + json2sheetOpts: { + // 鎸囧畾椤哄簭 + header: ['name', 'id'], + }, + }); + } + + function handleMultipleSheet() { + jsonToMultipleSheetXlsx({ + sheetList: [ + { data, - filename: '浣跨敤key浣滀负榛樿澶撮儴.xlsx', - }); - } - - function customHeader() { - jsonToSheetXlsx({ + sheetName: '浣跨敤key浣滀负榛樿澶撮儴', + }, + { data, header: { id: 'ID', @@ -41,49 +63,14 @@ beginTime: '寮�濮嬫椂闂�', endTime: '缁撴潫鏃堕棿', }, - filename: '鑷畾涔夊ご閮�.xlsx', json2sheetOpts: { // 鎸囧畾椤哄簭 header: ['name', 'id'], }, - }); - } - - function handleMultipleSheet() { - jsonToMultipleSheetXlsx({ - sheetList: [ - { - data, - sheetName: '浣跨敤key浣滀负榛樿澶撮儴', - }, - { - data, - header: { - id: 'ID', - name: '濮撳悕', - age: '骞撮緞', - no: '缂栧彿', - address: '鍦板潃', - beginTime: '寮�濮嬫椂闂�', - endTime: '缁撴潫鏃堕棿', - }, - json2sheetOpts: { - // 鎸囧畾椤哄簭 - header: ['name', 'id'], - }, - sheetName: '鑷畾涔夊ご閮�', - }, - ], - filename: '澶歋heet瀵煎嚭绀轰緥.xlsx', - }); - } - return { - defaultHeader, - customHeader, - handleMultipleSheet, - columns, - data, - }; - }, - }); + sheetName: '鑷畾涔夊ご閮�', + }, + ], + filename: '澶歋heet瀵煎嚭绀轰緥.xlsx', + }); + } </script> -- Gitblit v1.9.3