From 8fdaa589b3780ce6561d7f212faf2bd1d7544ad1 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期一, 13 二月 2023 14:36:11 +0800
Subject: [PATCH] 内阻数据导出
---
src/main/java/com/whyc/service/ExcelExportService.java | 77 ++++++++++++++++++++++----------------
1 files changed, 44 insertions(+), 33 deletions(-)
diff --git a/src/main/java/com/whyc/service/ExcelExportService.java b/src/main/java/com/whyc/service/ExcelExportService.java
index b41eb83..f958289 100644
--- a/src/main/java/com/whyc/service/ExcelExportService.java
+++ b/src/main/java/com/whyc/service/ExcelExportService.java
@@ -261,8 +261,7 @@
XSSFSheet sheet = wb.createSheet("鏁版嵁鎬昏〃");
//鍥剧墖鍏冪礌
XSSFDrawing patriarch = sheet.createDrawingPatriarch();
-
- int rowNumSheet = 0;
+ int rowNumSheet = 1;
//鎻掑叆鍥剧墖
int picNum = 0;
String[] picName =new String[]{"鍗曚綋鐢靛帇鎶樼嚎鍥�","鍗曚綋鍐呴樆鎶樼嚎鍥�","鍗曚綋娓╁害鎶樼嚎鍥�"};
@@ -282,38 +281,11 @@
RESDataInfo resDataInfo =resService.readFileData(filePath);
//浠庢枃浠朵腑鑾峰彇鏁版嵁
List<RESData> list = resDataInfo.resDatas;
- XSSFSheet sheet1 = wb.createSheet("鍐呴樆鏁版嵁");
- //鏂板缓琛�
-
- //鎶ご
- int rowNum = 0;
- sheet1.createRow(rowNum).createCell(0).setCellValue("娴嬭瘯鏁版嵁(鍐呴樆)");
- rowNum++;
- //灞炴�ф爮
- String[] rowName =new String[]{"娴嬭瘯鏃堕棿"};
- XSSFRow row = sheet1.createRow(rowNum);
- for (int i=0;i<rowName.length;i++){
- row.createCell(i).setCellValue(rowName[i]);
- }
int battNum=list.get(0).getBattSum();//鍗曚綋涓暟
- for(int i=0;i<battNum;i++){
- row.createCell(rowName.length+i).setCellValue("#"+Integer.valueOf(i+1));
- }
- rowNum++;
- //鏁版嵁鏍�
- for (int i = 0; i < list.size(); i++) {
- sheet1.createRow(rowNum); //鍒涘缓琛�
- RESData resData=list.get(i);
- float[] monomerRes=resData.getMonomerRes();
- sheet1.getRow(rowNum).createCell(0).setCellValue(resData.getData_Time());
- for (int k = 0;k<battNum;k++){
- sheet1.getRow(rowNum).createCell(k+1).setCellValue(monomerRes[i]);
- }
- rowNum++;
- }
-
- rowNum++;
-
+ //鍒涘缓涓嶅悓sheet
+ createBresSheet(wb,battNum,list,1);//鍒涘缓鍐呴樆鏁版嵁
+ createBresSheet(wb,battNum,list,2);//鍒涘缓娓╁害鏁版嵁
+ createBresSheet(wb,battNum,list,3);//鍒涘缓鐢靛帇鏁版嵁
try {
// 杞爜闃叉涔辩爜
resp.addHeader("Content-Disposition", "attachment;filename="
@@ -328,7 +300,46 @@
e.printStackTrace();
}
}
+ //bres涓唴闃绘暟鎹�/娓╁害鏁版嵁/鍗曚綋鐢靛帇鏁版嵁鏀惧湪涓嶅悓鐨剆heet涓�
+ public void createBresSheet(XSSFWorkbook wb,int battNum,List<RESData> list,int type){
+ String sheetName="";
+ String testName="";
+ switch (type){
+ case 1:sheetName= "鍐呴樆鏁版嵁";testName="娴嬭瘯鏁版嵁(鍐呴樆)";break;
+ case 2:sheetName= "娓╁害鏁版嵁";testName="娴嬭瘯鏁版嵁(娓╁害)";break;
+ case 3:sheetName= "鐢靛帇鏁版嵁";testName="娴嬭瘯鏁版嵁(鐢靛帇)";break;
+ }
+ XSSFSheet sheet1 = wb.createSheet(sheetName);
+ //鎶ご
+ int rowNum = 0;
+ sheet1.createRow(rowNum).createCell(0).setCellValue(testName);
+ rowNum++;
+ //灞炴�ф爮
+ XSSFRow row = sheet1.createRow(rowNum);
+ row.createCell(0).setCellValue("娴嬭瘯鏃堕棿");
+ for(int i=0;i<battNum;i++){
+ row.createCell(1+i).setCellValue("#"+Integer.valueOf(i+1));
+ }
+ rowNum++;
+ float[] datas=new float[]{};
+ //鏁版嵁鏍�
+ for (int i = 0; i < list.size(); i++) {
+ sheet1.createRow(rowNum); //鍒涘缓琛�
+ RESData resData= list.get(i);
+ switch (type){
+ case 1:datas= resData.getMonomerRes();break;
+ case 2:datas= resData.getMonomerTemp();break;
+ case 3:datas= resData.getMonomerVol();break;
+ }
+ sheet1.getRow(rowNum).createCell(0).setCellValue(formartDate(resData.getData_Time(),"yyyy-MM-dd HH:mm:ss"));
+ for (int k = 0;k<battNum;k++){
+ sheet1.getRow(rowNum).createCell(k+1).setCellValue(datas[i]);
+ }
+ rowNum++;
+ }
+ rowNum++;
+ }
/**
* 灏嗘棩鏈熸牸寮忚浆鎹㈡垚鎸囧畾鐨勫瓧绗︿覆鏍煎紡
--
Gitblit v1.9.1