From aee5d69235093cd1cf46ec685812985703e01541 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 17 十月 2024 16:57:17 +0800
Subject: [PATCH] 解析xls到tinf
---
src/main/java/com/whyc/controller/AnaysisController.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/controller/AnaysisController.java b/src/main/java/com/whyc/controller/AnaysisController.java
index cdc3c74..74fcd7d 100644
--- a/src/main/java/com/whyc/controller/AnaysisController.java
+++ b/src/main/java/com/whyc/controller/AnaysisController.java
@@ -4,10 +4,14 @@
import com.whyc.util.AnalysisUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
+import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.text.ParseException;
@RequestMapping("anaysis")
@@ -29,4 +33,18 @@
public Response getAnaysisXls(@RequestParam int battGroupId, @RequestParam int testRecordCount){
return service.getAnaysisXls(battGroupId,testRecordCount);
}
+
+ @ApiOperation("瑙ｆ瀽xls鏂囦欢鍒版斁鐢垫暟鎹腑")
+ @PostMapping("anaysisXlsToTdata")
+ public Response anaysisXlsToTdata(@RequestParam int battGroupId,@RequestParam MultipartFile multipartFile) throws IOException, InvalidFormatException, ParseException {
+ Response<Object> response = new Response<>();
+ String name=multipartFile.getOriginalFilename();
+ assert name != null;
+ if(!name.substring(name.length()-4).equals(".xls") && !name.substring(name.length()-5).equals(".xlsx")){
+ response.set(1,false,"鏂囦欢瑙ｆ瀽閿欒:涓婁紶鏍煎紡闈瀍xcel鏍煎紡");
+ }else{
+ response = service.anaysisXlsToTdata(battGroupId,multipartFile.getInputStream());
+ }
+ return response;
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1