From 81a9d00e46d37f950771d42aadb1f91c8069ba20 Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期一, 23 十二月 2024 11:34:08 +0800 Subject: [PATCH] bts充电数据导出 --- src/main/java/com/whyc/service/ExcelExportService.java | 28 ++++++++++++++-------------- 1 files changed, 14 insertions(+), 14 deletions(-) diff --git a/src/main/java/com/whyc/service/ExcelExportService.java b/src/main/java/com/whyc/service/ExcelExportService.java index 9d26cac..20a3f62 100644 --- a/src/main/java/com/whyc/service/ExcelExportService.java +++ b/src/main/java/com/whyc/service/ExcelExportService.java @@ -628,15 +628,15 @@ for (int i = 0; i < list.size(); i++) { sheet1.createRow(rowNum); //鍒涘缓琛� BTS_BattData fbsData= list.get(i); - sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime); - sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlineVol); - sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupVol); - sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battCurr); - sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battCap); - sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.battTemp); + sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime+""); + sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlineVol+""); + sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupVol+""); + sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battCurr+""); + sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battCap+""); + sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.battTemp+""); float[] datas=fbsData.monVol; for (int k = 0;k<battNum;k++){ - sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]); + sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]+""); } rowNum++; } @@ -775,15 +775,15 @@ for (int i = 0; i < list.size(); i++) { sheet1.createRow(rowNum); //鍒涘缓琛� BTS_BattData fbsData= list.get(i); - sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime); - sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlineVol); - sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupVol); - sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battCurr); - sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battCap); - sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.battTemp); + sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime+""); + sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlineVol+""); + sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupVol+""); + sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battCurr+""); + sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battCap+""); + sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.battTemp+""); float[] datas=fbsData.monVol; for (int k = 0;k<battNum;k++){ - sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]); + sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]+""); } rowNum++; } -- Gitblit v1.9.1