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/service/all/TestService.java | 41 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 41 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/service/all/TestService.java b/src/main/java/com/lf/server/service/all/TestService.java
index ab29d61..ebfce76 100644
--- a/src/main/java/com/lf/server/service/all/TestService.java
+++ b/src/main/java/com/lf/server/service/all/TestService.java
@@ -8,6 +8,7 @@
import com.lf.server.entity.all.PermsAuthEntity;
import com.lf.server.entity.all.ResAuthEntity;
import com.lf.server.entity.bd.DlgagnpEntity;
+import com.lf.server.entity.ctrl.CountEntity;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.md.MdzxcgEntity;
@@ -265,4 +266,44 @@
//
}
}
+
+ public void testWord() {
+ String inputFile = "C:\\Users\\Administrator\\Desktop\\ts\\椤圭洰鏁版嵁鍒嗙被缁熻.docx";
+ String outPutFile = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.docx";
+
+ Map<String, String> textMap = new HashMap<>();
+ textMap.put("title", "娣卞湷娑插寲澶╃劧姘斿簲鎬ヨ皟宄扮珯澶栬緭绠￠亾宸ョ▼锛圶Q03T04锛�");
+
+ List<String[]> tableList = new ArrayList<>();
+ tableList.add(new String[]{"" + 1, "鏁板瓧绾垮垝鍥�", "123.54骞虫柟绫�"});
+ tableList.add(new String[]{"" + 2, "鍦扮伨鐐�", "120涓�"});
+
+ WordHelper.generateWord(inputFile, outPutFile, textMap, tableList);
+ }
+
+ public void testExcel() {
+ String source = "C:\\Users\\Administrator\\Desktop\\ts\\椤圭洰鏁版嵁鍒嗙被缁熻.xlsx";
+ String target = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.xlsx";
+
+ List<CountEntity> list = new ArrayList<>();
+ CountEntity c1 = new CountEntity();
+ c1.setNo(1);
+ c1.setM1("鏁板瓧绾垮垝鍥�");
+ c1.setM2("123.54骞虫柟绫�");
+ list.add(c1);
+
+ CountEntity c2 = new CountEntity();
+ c2.setNo(2);
+ c2.setM1("鍦扮伨鐐�");
+ c2.setM2("120涓�");
+ list.add(c2);
+
+ Map<String, Object> map = new HashMap<>(1);
+ map.put("title", "娣卞湷娑插寲澶╃劧姘斿簲鎬ヨ皟宄扮珯澶栬緭绠￠亾宸ョ▼锛圶Q03T04锛�");
+
+ Map<String, List<CountEntity>> listMap = new HashMap<>(1);
+ listMap.put("data", list);
+
+ ExcelHelper.writeToTemplate(source, target, map, listMap);
+ }
}
--
Gitblit v1.9.3