From f7a31eb39041a26b56dc5fd4c50926f550cf1474 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期三, 11 九月 2024 16:11:39 +0800
Subject: [PATCH] 导出
---
src/main/java/com/whyc/service/ExcelExportService.java | 46 ++++++++++++++++++++++++----------------------
1 files changed, 24 insertions(+), 22 deletions(-)
diff --git a/src/main/java/com/whyc/service/ExcelExportService.java b/src/main/java/com/whyc/service/ExcelExportService.java
index e686188..4f22a14 100644
--- a/src/main/java/com/whyc/service/ExcelExportService.java
+++ b/src/main/java/com/whyc/service/ExcelExportService.java
@@ -36,29 +36,31 @@
}
rowNum++;
List<BatttestdataId> list=subService.getTdataById(devId,testRecordCount);
- //鏁版嵁鏍�
- for (int i = 0; i < list.size(); i++) {
- sheet.createRow(rowNum); //鍒涘缓琛�
- BatttestdataId tdata=list.get(i);
- for(int j=0;j<titiles.length;j++){
- sheet.getRow(rowNum).createCell(0 ).setCellValue(ActionUtil.secToTime(tdata.getTestTimelong()));
- sheet.getRow(rowNum).createCell(1).setCellValue(tdata.getBattIdx()+1);
- sheet.getRow(rowNum).createCell(2 ).setCellValue(tdata.getMonNum());
- sheet.getRow(rowNum).createCell(3).setCellValue(tdata.getTestRecordCount());
- sheet.getRow(rowNum).createCell(4).setCellValue(tdata.getTestType());
- sheet.getRow(rowNum).createCell(5).setCellValue(tdata.getRecordNum());
- sheet.getRow(rowNum).createCell(6).setCellValue(tdata.getGroupVol());
- sheet.getRow(rowNum).createCell(7).setCellValue(tdata.getTestCurr());
- sheet.getRow(rowNum).createCell(8).setCellValue(tdata.getTestCap());
- sheet.getRow(rowNum).createCell(9 ).setCellValue(tdata.getMonVol());
- sheet.getRow(rowNum).createCell(10 ).setCellValue(tdata.getMonTmp());
- sheet.getRow(rowNum).createCell(11 ).setCellValue(tdata.getMonCurr());
- sheet.getRow(rowNum).createCell(12 ).setCellValue(tdata.getMonCap());
- sheet.getRow(rowNum).createCell(13 ).setCellValue(tdata.getMonWh());
- sheet.getRow(rowNum).createCell(14 ).setCellValue(tdata.getMonState());
- sheet.getRow(rowNum).createCell(15 ).setCellValue(tdata.getMonFault());
+ if(list!=null){
+ //鏁版嵁鏍�
+ for (int i = 0; i < list.size(); i++) {
+ sheet.createRow(rowNum); //鍒涘缓琛�
+ BatttestdataId tdata=list.get(i);
+ for(int j=0;j<titiles.length;j++){
+ sheet.getRow(rowNum).createCell(0 ).setCellValue(ActionUtil.secToTime(tdata.getTestTimelong()));
+ sheet.getRow(rowNum).createCell(1).setCellValue(tdata.getBattIdx()+1);
+ sheet.getRow(rowNum).createCell(2 ).setCellValue(tdata.getMonNum());
+ sheet.getRow(rowNum).createCell(3).setCellValue(tdata.getTestRecordCount());
+ sheet.getRow(rowNum).createCell(4).setCellValue(tdata.getTestType());
+ sheet.getRow(rowNum).createCell(5).setCellValue(tdata.getRecordNum());
+ sheet.getRow(rowNum).createCell(6).setCellValue(tdata.getGroupVol());
+ sheet.getRow(rowNum).createCell(7).setCellValue(tdata.getTestCurr());
+ sheet.getRow(rowNum).createCell(8).setCellValue(tdata.getTestCap());
+ sheet.getRow(rowNum).createCell(9 ).setCellValue(tdata.getMonVol());
+ sheet.getRow(rowNum).createCell(10 ).setCellValue(tdata.getMonTmp());
+ sheet.getRow(rowNum).createCell(11 ).setCellValue(tdata.getMonCurr());
+ sheet.getRow(rowNum).createCell(12 ).setCellValue(tdata.getMonCap());
+ sheet.getRow(rowNum).createCell(13 ).setCellValue(tdata.getMonWh());
+ sheet.getRow(rowNum).createCell(14 ).setCellValue(tdata.getMonState());
+ sheet.getRow(rowNum).createCell(15 ).setCellValue(tdata.getMonFault());
+ }
+ rowNum++;
}
- rowNum++;
}
try {
// 鍐欏叆鍒拌緭鍑烘祦
--
Gitblit v1.9.1