From b27e55f4de22d27588033ef369048ed2e23f93b5 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期一, 06 六月 2022 15:16:20 +0800
Subject: [PATCH] add 增加 Excel 模板导出 测试类
---
ruoyi-demo/src/main/resources/excel/多列表.xlsx | 0
ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestExcelController.java | 102 +++++++++++++++++++++++++++++++++++++++++++++++++++
ruoyi-demo/src/main/resources/excel/单列表.xlsx | 0
3 files changed, 102 insertions(+), 0 deletions(-)
diff --git a/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestExcelController.java b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestExcelController.java
new file mode 100644
index 0000000..a318b46
--- /dev/null
+++ b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestExcelController.java
@@ -0,0 +1,102 @@
+package com.ruoyi.demo.controller;
+
+import cn.hutool.core.collection.CollUtil;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * 娴嬭瘯Excel鍔熻兘
+ *
+ * @author Lion Li
+ */
+@Api(value = "娴嬭瘯Excel鍔熻兘", tags = {"娴嬭瘯Excel鍔熻兘"})
+@RestController
+@RequestMapping("/demo/excel")
+public class TestExcelController {
+
+ /**
+ * 鍗曞垪琛ㄥ鏁版嵁
+ */
+ @ApiOperation(value = "鍗曞垪琛ㄥ鏁版嵁")
+ @GetMapping("/exportTemplateOne")
+ public void exportTemplateOne(HttpServletResponse response) {
+ Map<String,String> map = new HashMap<>();
+ map.put("title","鍗曞垪琛ㄥ鏁版嵁");
+ map.put("test1","鏁版嵁娴嬭瘯1");
+ map.put("test2","鏁版嵁娴嬭瘯2");
+ map.put("test3","鏁版嵁娴嬭瘯3");
+ map.put("test4","鏁版嵁娴嬭瘯4");
+ map.put("testTest","666");
+ List<TestObj> list = new ArrayList<>();
+ list.add(new TestObj("鍗曞垪琛ㄦ祴璇�1", "鍒楄〃娴嬭瘯1", "鍒楄〃娴嬭瘯2", "鍒楄〃娴嬭瘯3", "鍒楄〃娴嬭瘯4"));
+ list.add(new TestObj("鍗曞垪琛ㄦ祴璇�2", "鍒楄〃娴嬭瘯5", "鍒楄〃娴嬭瘯6", "鍒楄〃娴嬭瘯7", "鍒楄〃娴嬭瘯8"));
+ list.add(new TestObj("鍗曞垪琛ㄦ祴璇�3", "鍒楄〃娴嬭瘯9", "鍒楄〃娴嬭瘯10", "鍒楄〃娴嬭瘯11", "鍒楄〃娴嬭瘯12"));
+ ExcelUtil.exportTemplate(CollUtil.newArrayList(map,list),"鍗曞垪琛�.xlsx", "excel/鍗曞垪琛�.xlsx", response);
+ }
+
+ /**
+ * 澶氬垪琛ㄥ鏁版嵁
+ */
+ @ApiOperation(value = "澶氬垪琛ㄥ鏁版嵁")
+ @GetMapping("/exportTemplateMuliti")
+ public void exportTemplateMuliti(HttpServletResponse response) {
+ Map<String,String> map = new HashMap<>();
+ map.put("title1","鏍囬1");
+ map.put("title2","鏍囬2");
+ map.put("title3","鏍囬3");
+ map.put("title4","鏍囬4");
+ map.put("author","Lion Li");
+ List<TestObj1> list1 = new ArrayList<>();
+ list1.add(new TestObj1("list1娴嬭瘯1", "list1娴嬭瘯2", "list1娴嬭瘯3"));
+ list1.add(new TestObj1("list1娴嬭瘯4", "list1娴嬭瘯5", "list1娴嬭瘯6"));
+ list1.add(new TestObj1("list1娴嬭瘯7", "list1娴嬭瘯8", "list1娴嬭瘯9"));
+ List<TestObj1> list2 = new ArrayList<>();
+ list2.add(new TestObj1("list2娴嬭瘯1", "list2娴嬭瘯2", "list2娴嬭瘯3"));
+ list2.add(new TestObj1("list2娴嬭瘯4", "list2娴嬭瘯5", "list2娴嬭瘯6"));
+ List<TestObj1> list3 = new ArrayList<>();
+ list3.add(new TestObj1("list3娴嬭瘯1", "list3娴嬭瘯2", "list3娴嬭瘯3"));
+ List<TestObj1> list4 = new ArrayList<>();
+ list4.add(new TestObj1("list4娴嬭瘯1", "list4娴嬭瘯2", "list4娴嬭瘯3"));
+ list4.add(new TestObj1("list4娴嬭瘯4", "list4娴嬭瘯5", "list4娴嬭瘯6"));
+ list4.add(new TestObj1("list4娴嬭瘯7", "list4娴嬭瘯8", "list4娴嬭瘯9"));
+ list4.add(new TestObj1("list4娴嬭瘯10", "list4娴嬭瘯11", "list4娴嬭瘯12"));
+ Map<String,Object> multiListMap = new HashMap<>();
+ multiListMap.put("map",map);
+ multiListMap.put("data1",list1);
+ multiListMap.put("data2",list2);
+ multiListMap.put("data3",list3);
+ multiListMap.put("data4",list4);
+ ExcelUtil.exportTemplateMultiList(multiListMap, "澶氬垪琛�.xlsx", "excel/澶氬垪琛�.xlsx", response);
+ }
+
+ @Data
+ @AllArgsConstructor
+ static class TestObj1 {
+ private String test1;
+ private String test2;
+ private String test3;
+ }
+
+ @Data
+ @AllArgsConstructor
+ static class TestObj {
+ private String name;
+ private String list1;
+ private String list2;
+ private String list3;
+ private String list4;
+ }
+
+}
diff --git "a/ruoyi-demo/src/main/resources/excel/\345\215\225\345\210\227\350\241\250.xlsx" "b/ruoyi-demo/src/main/resources/excel/\345\215\225\345\210\227\350\241\250.xlsx"
new file mode 100644
index 0000000..0f7347d
--- /dev/null
+++ "b/ruoyi-demo/src/main/resources/excel/\345\215\225\345\210\227\350\241\250.xlsx"
Binary files differ
diff --git "a/ruoyi-demo/src/main/resources/excel/\345\244\232\345\210\227\350\241\250.xlsx" "b/ruoyi-demo/src/main/resources/excel/\345\244\232\345\210\227\350\241\250.xlsx"
new file mode 100644
index 0000000..c7d11dc
--- /dev/null
+++ "b/ruoyi-demo/src/main/resources/excel/\345\244\232\345\210\227\350\241\250.xlsx"
Binary files differ
--
Gitblit v1.9.3