bts充电数据导出

whyclxw

2024-12-19 075d7497862ebd4fa2edc710d7b2256cd0fe6787

bts充电数据导出

 src/main/java/com/whyc/service/ExcelExportService.java

@@ -599,7 +599,7 @@
        }

        //从文件中获取数据
        List<BTS_FbsData> list=disData.fbsDatas;//放电数据
        List<BTS_BattData> list=disData.fbsDatas;//放电数据
        String sheetName="放电数据";
        String testName="测试数据";
        XSSFSheet sheet1 = wb.createSheet(sheetName);
@@ -621,14 +621,14 @@
        //数据栏
        for (int i = 0; i < list.size(); i++) {
            sheet1.createRow(rowNum);  //创建行
            BTS_FbsData fbsData= list.get(i);
            BTS_BattData fbsData= list.get(i);
            sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime);
            sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlinevol[0]);
            sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupvol[0]);
            sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battcurr[0]);
            sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battcap[0]);
            sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.batttemp[0]);
            double[]  datas=fbsData.vol;
            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);
            double[]  datas=fbsData.monVol;
            for (int k = 0;k<battNum;k++){
                sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]);
            }
@@ -741,7 +741,7 @@
        }

        //从文件中获取数据
        List<BTS_FbsData> list=chargeData.fbsDatas;//放电数据
        List<BTS_BattData> list=chargeData.fbsDatas;//放电数据
        String sheetName="充电数据";
        String testName="测试数据";
        XSSFSheet sheet1 = wb.createSheet(sheetName);
@@ -763,14 +763,14 @@
        //数据栏
        for (int i = 0; i < list.size(); i++) {
            sheet1.createRow(rowNum);  //创建行
            BTS_FbsData fbsData= list.get(i);
            BTS_BattData fbsData= list.get(i);
            sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.testTime);
            sheet1.getRow(rowNum).createCell(1).setCellValue(fbsData.onlinevol[0]);
            sheet1.getRow(rowNum).createCell(2).setCellValue(fbsData.groupvol[0]);
            sheet1.getRow(rowNum).createCell(3).setCellValue(fbsData.battcurr[0]);
            sheet1.getRow(rowNum).createCell(4).setCellValue(fbsData.battcap[0]);
            sheet1.getRow(rowNum).createCell(5).setCellValue(fbsData.batttemp[0]);
            double[]  datas=fbsData.vol;
            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);
            double[]  datas=fbsData.monVol;
            for (int k = 0;k<battNum;k++){
                sheet1.getRow(rowNum).createCell(k+6).setCellValue(datas[k]);
            }