From d3d7dcf919eda40a415b6dc744fb0b347d4293a8 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期三, 30 八月 2023 16:10:29 +0800
Subject: [PATCH] 扬尘Vue代码
---
src/utils/common.js | 40 ++++++++++++++++++++++++++++++++++++++--
1 files changed, 38 insertions(+), 2 deletions(-)
diff --git a/src/utils/common.js b/src/utils/common.js
index 62bd9f7..d105ca4 100644
--- a/src/utils/common.js
+++ b/src/utils/common.js
@@ -1,3 +1,4 @@
+import * as XLSX from 'xlsx/xlsx.mjs';
export function useCommonFunction(){
/**
* description锛氬垽鏂捣濮嬫椂闂磋法搴︽槸鍚﹁秴杩�1涓湀
@@ -53,8 +54,43 @@
* @returns锛氬ぇ浜庯紝鍒欒繑鍥瀟rue銆傚惁鍒欒繑鍥瀎alse
*/
function cmpp(a, b) {
- return Number(a.replace('%', '')) > Number(b.replace('%', ''));
+ return Number(a.replace('%', '')) >= Number(b.replace('%', ''));
}
- return {isExceedOneMonth,cmpp}
+ /**
+ *瀵煎嚭涓篹xcel
+ * @param锛� 琛ㄦ牸鏁版嵁锛屽緟瀵煎嚭鐨勮〃鏍煎垪锛宔xcel鍒楋紝excel鏂囦欢鍚�
+ * @returns
+ */
+ function exportToExcel(exportData,tableColumns,excelColumnsName,excelName='data.xlsx'){
+ const itemsFormatted = exportData.map((item) => {
+ const newItem = {};
+ tableColumns.forEach((col) => {
+ newItem[col] = item[col];
+ });
+ return newItem;
+ });
+ // 鍒涘缓xlsx瀵硅薄
+ const xls = XLSX.utils.json_to_sheet(itemsFormatted);
+
+ // xls['A1'].v = '璁惧缂栧彿';
+ // xls['B1'].v = '寮傚父绫诲瀷';
+ // xls['C1'].v = '鍦板尯';
+ // xls['D1'].v = '寮�濮嬫椂闂�';
+ // xls['E1'].v = '缁撴潫鏃堕棿';
+
+ // 缂栬緫琛ㄥご琛� 淇敼琛ㄥご
+ excelColumnsName.forEach(item =>{
+ xls[item[0]].v = item[1]
+ })
+ // 鍒涘缓workbook锛屽苟鎶妔heet娣诲姞杩涘幓
+ const wb = XLSX.utils.book_new();
+ XLSX.utils.book_append_sheet(wb, xls, 'Sheet1');
+ // 灏唚orkbook杞负浜岃繘鍒秞lsx鏂囦欢骞朵笅杞�
+ XLSX.writeFile(wb, excelName);
+
+ }
+
+ return {isExceedOneMonth,cmpp,exportToExcel}
}
+
--
Gitblit v1.9.3