From ba0f0245d0f2824034319fcc1e960a75cfd8ca87 Mon Sep 17 00:00:00 2001
From: zhaojiale <631455805@qq.com>
Date: 星期二, 09 八月 2022 14:24:25 +0800
Subject: [PATCH] 目标汇总导出
---
src/views/goalManagement/Goalsummary/index.vue | 18 ++++++++++++++++--
package.json | 3 ++-
2 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/package.json b/package.json
index fbe32d7..b027980 100644
--- a/package.json
+++ b/package.json
@@ -33,7 +33,8 @@
"vue-clipboard3": "^2.0.0",
"vue-grid-layout": "^3.0.0-beta1",
"vue-i18n": "^9.1.10",
- "vue-router": "^4.0.15"
+ "vue-router": "^4.0.15",
+ "xlsx": "^0.18.5"
},
"devDependencies": {
"@types/node": "^17.0.39",
diff --git a/src/views/goalManagement/Goalsummary/index.vue b/src/views/goalManagement/Goalsummary/index.vue
index 4d241e4..a345459 100644
--- a/src/views/goalManagement/Goalsummary/index.vue
+++ b/src/views/goalManagement/Goalsummary/index.vue
@@ -24,10 +24,10 @@
<div class="btns">
<p>汇总日期:2022-07-04 23:00:07</p>
<div>
- <el-button type="primary" size="default" :icon="Download">导出</el-button>
+ <el-button type="primary" size="default" :icon="Download" @click="exportExcel('tab1', '会员明细.xlsx')">导出</el-button>
</div>
</div>
- <el-table :data="tableData" style="width: 100%">
+ <el-table :data="tableData" style="width: 100%" id="tab1">
<el-table-column label="责任部门" align="center">
<template #default="scope">{{ scope.row.departmentId }}</template>
</el-table-column>
@@ -68,6 +68,9 @@
import { ElMessageBox, ElMessage, ElButton, ElInput, TabsPaneContext, FormInstance } from 'element-plus';
import { Plus, Delete, Upload, Download, Refresh, View } from '@element-plus/icons-vue';
import { goalManagementApi } from '/@/api/goalManagement';
+
+import * as XLSX from 'xlsx';
+
export default defineComponent({
components: { ElButton, ElInput },
setup() {
@@ -162,6 +165,16 @@
],
},
];
+
+ const exportExcel = (id:string,name:string) => {
+ let workbook = XLSX.utils.table_to_book(document.getElementById(id)); //需要在table上定义一个id
+ try {
+ XLSX.writeFile(workbook, name);
+ console.log('导出成功!');
+ } catch (e) {
+ console.log('导出失败!');
+ }
+ }
return {
ruleForm,
tableData,
@@ -179,6 +192,7 @@
Download,
Refresh,
View,
+ exportExcel
};
},
});
--
Gitblit v1.9.2