From c1655e378010a1c53b4ac31957545f877c68eefb Mon Sep 17 00:00:00 2001
From: longyvfengyun <496960745@qq.com>
Date: 星期四, 21 七月 2022 11:54:13 +0800
Subject: [PATCH] excel解析
---
src/main/java/com/whyc/service/ProductBomApprovingService.java | 13 +++++++------
1 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomApprovingService.java b/src/main/java/com/whyc/service/ProductBomApprovingService.java
index f5c9197..f6f5c96 100644
--- a/src/main/java/com/whyc/service/ProductBomApprovingService.java
+++ b/src/main/java/com/whyc/service/ProductBomApprovingService.java
@@ -120,17 +120,18 @@
DocUser user = ActionUtil.getUser();
String dateFormat = new SimpleDateFormat("YYYY-MM").format(new Date());
long timeStamp = System.currentTimeMillis();
- String zipPath = rootFile + File.separator + "product_approving" + File.separator + user.getName() + File.separator + dateFormat+ File.separator + timeStamp;
- File zipFile = new File(zipPath);
+ String filePath = rootFile + File.separator + "product_approving" + File.separator + user.getName() + File.separator + dateFormat+ File.separator + timeStamp;
+ File parentFile = new File(filePath);
+ File zipFile = new File(filePath+File.separator+file.getOriginalFilename());
if(!zipFile.exists()){
zipFile.mkdirs();
}
file.transferTo(zipFile);
//瑙ｅ帇鏂囦欢澶�
- Zip4jUtil.unPackZip(zipFile,null,zipPath);
+ Zip4jUtil.unPackZip(zipFile,null,filePath);
//閬嶅巻瑙ｅ帇鍚庣殑鏂囦欢澶硅矾寰�,瑙ｆ瀽excel
- System.out.println(zipPath);
- File[] bomFileDirArr = zipFile.listFiles();
+ System.out.println(filePath);
+ File[] bomFileDirArr = parentFile.listFiles();
for (File bomFileDir : bomFileDirArr){
String bomFileDirName = bomFileDir.getName();
System.out.println(bomFileDirName);
@@ -138,7 +139,7 @@
for (File bomFile : bomFileArr){
String bomFileName = bomFile.getName();
//瑙ｆ瀽excel
- while (bomFileName.contains(".xls")){
+ if (bomFileName.contains(".xls")){
System.out.println("寰呰В鏋愮殑excel鏂囦欢涓�:"+bomFileName);
}
}
--
Gitblit v1.9.1