From 2f55cebbad3dea187a5f91d16ec80a9677dab699 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 13 十一月 2024 11:16:53 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/utils/ExcelUtils.java | 33 +--------------------------------
1 files changed, 1 insertions(+), 32 deletions(-)
diff --git a/src/main/java/com/yssh/utils/ExcelUtils.java b/src/main/java/com/yssh/utils/ExcelUtils.java
index c3b81ba..d18213b 100644
--- a/src/main/java/com/yssh/utils/ExcelUtils.java
+++ b/src/main/java/com/yssh/utils/ExcelUtils.java
@@ -10,23 +10,11 @@
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.metadata.fill.FillConfig;
import com.alibaba.excel.write.metadata.fill.FillWrapper;
-import com.yssh.entity.ExcelHead;
+import com.yssh.entity.xls.ExcelHead;
import java.util.*;
-/**
- * Excel甯姪绫�
- * @author WWW
- * @date 2023-08-08
- */
public class ExcelUtils {
- /**
- * 璇诲彇Excel
- *
- * @param pathName 鏂囦欢璺緞
- * @param <T> 娉涘瀷绫�
- * @return 娉涘瀷绫婚泦鍚�
- */
public static <T> List<T> readExcel(Class<?> clazz, String pathName) {
ExcelHead head = getExcelHead(clazz);
int headRowNumber = head == null ? 1 : head.headRows();
@@ -59,40 +47,21 @@
return list;
}
- /**
- * 鑾峰彇Excel澶存敞瑙ｇ被
- *
- * @param clazz Class
- * @param <T> 娉涘瀷绫�
- * @return 澶磋鏁�
- */
public static <T> ExcelHead getExcelHead(Class<?> clazz) {
ExcelHead head = clazz.getAnnotation(ExcelHead.class);
return head;
}
- /**
- * 鍐欏叆Excel妯℃澘
- *
- * @param source 婧愭枃浠讹紙妯℃澘锛�
- * @param target 鐩綍鏂囦欢
- * @param map 鏁版嵁婧�
- */
public static <T> void writeToTemplate(String source, String target, Map<String, List<T>> map) {
- // 鏍规嵁妯℃澘鍐欏叆鏁版嵁锛屽鏋滅洰鏍囨枃浠朵笉瀛樺湪锛屽垯鑷姩鍒涘缓鏂囦欢
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();
- // 鍐欏叆鏁版嵁
map.forEach((k, v) -> excelWriter.fill(new FillWrapper(k, v), fillConfig, writeSheet));
- // 缁撴潫鍐欏叆
excelWriter.finish();
}
}
--
Gitblit v1.9.3