From 06ef175a1e9f72b3863757319b2f6ff76c5a2f05 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 03 十二月 2024 09:16:55 +0800
Subject: [PATCH] zjh20241202-3
---
ltkj-common/src/main/java/com/ltkj/common/excelConfig/ExcelUtils.java | 46 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 45 insertions(+), 1 deletions(-)
diff --git a/ltkj-common/src/main/java/com/ltkj/common/excelConfig/ExcelUtils.java b/ltkj-common/src/main/java/com/ltkj/common/excelConfig/ExcelUtils.java
index 8c49cf0..8ad42e9 100644
--- a/ltkj-common/src/main/java/com/ltkj/common/excelConfig/ExcelUtils.java
+++ b/ltkj-common/src/main/java/com/ltkj/common/excelConfig/ExcelUtils.java
@@ -2,6 +2,7 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
+import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
@@ -34,6 +35,7 @@
* 鍘熸枃閾炬帴锛堜笉瀹氭椂澧炲姞鏂板姛鑳斤級: https://zyqok.blog.csdn.net/article/details/121994504
*/
@SuppressWarnings("unused")
+@Slf4j
public class ExcelUtils {
private static final String XLSX = ".xlsx";
@@ -61,6 +63,7 @@
public static <T> List<T> readMultipartFile(MultipartFile mFile, Class<T> clazz) throws Exception {
JSONArray array = readMultipartFile(mFile);
+ log.info("array鎵ц鍑烘潵鏄�:"+array);
return getBeanList(array, clazz);
}
@@ -214,8 +217,9 @@
}
// 鍏朵綑鎯呭喌鏍规嵁绫诲瀷璧嬪��
String fieldClassName = field.getType().getSimpleName();
+ String name = field.getName();
try {
- if ("String".equalsIgnoreCase(fieldClassName)) {
+ if ("String".equalsIgnoreCase(fieldClassName) || name.equals("phoe")) {
field.set(t, val);
} else if ("boolean".equalsIgnoreCase(fieldClassName)) {
field.set(t, Boolean.valueOf(val));
@@ -298,6 +302,7 @@
return null;
}
in.close();
+// Workbook zhuanhuanexcel = zhuanhuanexcel(in);
return book;
}
@@ -1005,4 +1010,43 @@
return s.trim();
}
+ private static Workbook zhuanhuanexcel(InputStream inputStream){
+ Workbook workbook = null;
+ try {
+ workbook = WorkbookFactory.create(inputStream);
+ Sheet sheet = workbook.getSheetAt(0); // 鑾峰彇绗竴涓猄heet椤�
+
+ for (Row row : sheet) {
+ for (Cell cell : row) {
+ // 妫�鏌ュ崟鍏冩牸鐨勭被鍨嬪苟杞崲涓烘枃鏈�
+ switch (cell.getCellType()) {
+ case STRING:
+ System.out.print(cell.getStringCellValue() + "\t");
+ break;
+ case NUMERIC:
+ System.out.print(cell.getNumericCellValue() + "\t");
+ break;
+ case BOOLEAN:
+ System.out.print(cell.getBooleanCellValue() + "\t");
+ break;
+ case FORMULA:
+ System.out.print(cell.getCellFormula() + "\t");
+ break;
+ default: break;
+ }
+ }
+ System.out.println(); // 鎹㈣锛岃〃绀轰竴琛屾暟鎹粨鏉�
+ }
+ } catch (IOException e) {
+ throw new RuntimeException(e);
+ } finally {
+ try {
+ workbook.close();
+ } catch (IOException e) {
+ throw new RuntimeException(e);
+ }
+ }
+ return workbook;
+ }
+
}
--
Gitblit v1.8.0