From b9b490e0ec226389c6e2502fecf918f7537d8c57 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 21 三月 2024 10:57:52 +0800
Subject: [PATCH] 添加Word Excel测试方法
---
src/main/java/com/lf/server/helper/ExcelHelper.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/helper/ExcelHelper.java b/src/main/java/com/lf/server/helper/ExcelHelper.java
index 060653c..d0abdca 100644
--- a/src/main/java/com/lf/server/helper/ExcelHelper.java
+++ b/src/main/java/com/lf/server/helper/ExcelHelper.java
@@ -74,6 +74,32 @@
/**
* 鍐欏叆Excel妯℃澘
*
+ * @param source 婧愭枃浠讹紙妯℃澘锛�
+ * @param target 鐩綍鏂囦欢
+ * @param map 閿�煎Map
+ * @param listMap 鍒楄〃Map
+ */
+ public static <T> void writeToTemplate(String source, String target, Map<String, Object> map, Map<String, List<T>> listMap) {
+ // 鏍规嵁妯℃澘鍐欏叆鏁版嵁锛屽鏋滅洰鏍囨枃浠朵笉瀛樺湪锛屽垯鑷姩鍒涘缓鏂囦欢
+ ExcelWriter excelWriter = EasyExcel.write(target).withTemplate(source).build();
+
+ // 鍦ㄥ伐浣滅翱0涓啓鍏ユ暟鎹紝濡傛灉妯℃澘涓笉瀛樺湪缁冧範宸ヤ綔绨匡紝鍒欎細鍦ㄧ洰鏍囨枃浠朵腑鑷姩鍒涘缓
+ WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
+
+ // 鍨傜洿鍐欏叆鏁版嵁锛屽鏋滆姘村钩鍐欏叆锛屽皢VERTICAL鏇挎崲涓篐ORIZONTAL
+ FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.VERTICAL).build();
+
+ // 鍐欏叆鏁版嵁
+ excelWriter.fill(map, writeSheet);
+ listMap.forEach((k, v) -> excelWriter.fill(new FillWrapper(k, v), fillConfig, writeSheet));
+
+ // 缁撴潫鍐欏叆
+ excelWriter.finish();
+ }
+
+ /**
+ * 鍐欏叆Excel妯℃澘
+ *
* @param source 婧愭枃浠讹紙妯℃澘锛�
* @param target 鐩綍鏂囦欢
* @param map 鏁版嵁婧�
--
Gitblit v1.9.3