bts充电数据导出

whyclxw

2024-12-23 81a9d00e46d37f950771d42aadb1f91c8069ba20

bts充电数据导出

 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++;
        }