文件解析充电数据导出

lxw

2023-05-17 a56c965e004eb45b2a66b5989615c06b7b164406

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

@@ -31,7 +31,6 @@

    //导出放电数据bcp
    public void exportBcp(HttpServletRequest req, HttpServletResponse resp) {

        String curr_echart = req.getParameter("curr_echart");        //电池电流折线图
        String groupVol_echart = req.getParameter("groupVol_echart");//组端电压折线图
        String cap_echart = req.getParameter("cap_echart");            //测试容量折线图
@@ -91,7 +90,6 @@
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("测试开始时间：" + formartDate(capState.StartDT.time,"yyyy-MM-dd HH:mm:ss"));
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("测试时长：" + capState.Test_Time.hour+":"+capState.Test_Time.minute+":"+capState.Test_Time.second);


        rowNumSheet += 4;
        //插入图片
@@ -186,14 +184,14 @@
            return picNameBcp;
        }else if(fileType.equals("chr")){
            String[] picNameChr = new String[]{
                    "电池电流折线图","组端电压折线图","测试容量折线图","单体电压折线图","环境温度折线图","环境湿度折线图"
                    "电池电流折线图","组端电压折线图","测试容量折线图","温度折线图"
            };
            return picNameChr;
        }else if(fileType.equals("alm")){
            String[] picNameChr = new String[]{
                    "电池电流折线图","组端电压折线图","测试容量折线图","单体电压折线图","环境温度折线图","环境湿度折线图"
            String[] picNameAlm = new String[]{
                    "电池电流折线图","组端电压折线图","测试容量折线图","温度折线图"
            };
            return picNameChr;
            return picNameAlm;
        }else{
            return null;
        }
@@ -201,41 +199,69 @@


    //导出充电数据chr
    /*public void exportChr(HttpServletRequest req, HttpServletResponse resp){
        String volEchart = req.getParameter("vol_echart");         //单体电压折线图
        String resEchart = req.getParameter("res_echart");         //单体内阻折线图
        String tmpEchart = req.getParameter("tmp_echart");         //单体温度折线图

    public void exportChr(HttpServletRequest req, HttpServletResponse resp){
        String curr_echart = req.getParameter("curr_echart");        //电池电流折线图
        String groupVol_echart = req.getParameter("groupVol_echart");//组端电压折线图
        String cap_echart = req.getParameter("cap_echart");            //测试容量折线图
        String temp_echart = req.getParameter("temp_echart");//温度折线图
        String filePath = req.getParameter("filePath");
        Fbs5100ChargeData data=chargeDataService.readFileData(filePath);
        //图片base64后的数据
        List<byte[]> bytes = new ArrayList<>();
        try {
            if (ServletUtils.isNotNull(volEchart)) {
                String[] url = volEchart.split(",");
            if (ServletUtils.isNotNull(curr_echart)) {
                String[] url = curr_echart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(resEchart)) {
                String[] url = resEchart.split(",");
            if (ServletUtils.isNotNull(groupVol_echart)) {
                String[] url = groupVol_echart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(tmpEchart)) {
                String[] url = tmpEchart.split(",");
            if (ServletUtils.isNotNull(cap_echart)) {
                String[] url = cap_echart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(temp_echart)) {
                String[] url = temp_echart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        //数据
        Fbs5100BattParam battParam =data.battParam;
        Fbs5100ChargeParam chargeParam =data.chargeParam;
        Fbs5100ChargeState chargeState =data.chargeState;
        //从文件中获取数据
        List<Fbs5100FbsData> list = data.fbsDatas;
        //当前日期
        String nowFormat = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
        String excelName = "BRES-"+nowFormat;
        String excelName = "chr-"+nowFormat;
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet("数据总表");
        int rowNumSheet = 0;
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("电池组数：" + battParam.BattGroupCount);
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("每组单体数：" + battParam.EachGroupBattCount);
        sheet.getRow(rowNumSheet).createCell(2).setCellValue("标称单体电压：" + battParam.MonomerVol + "V");

        rowNumSheet++;
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("浮充电流阈值：" + battParam.FloatChargeVol + "A");
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("在线电压低阈值：" + battParam.OnlineVolLow + "A");
        sheet.getRow(rowNumSheet).createCell(2).setCellValue("均充电压：" + battParam.JunChargeVol + "A");

        rowNumSheet++;
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("测试开始时间：" + formartDate(chargeState.StartDT.time,"yyyy-MM-dd HH:mm:ss"));
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("测试时长：" + chargeState.Test_Time.hour+":"+chargeState.Test_Time.minute+":"+chargeState.Test_Time.second);

        rowNumSheet += 4;
        //图片元素
        XSSFDrawing patriarch = sheet.createDrawingPatriarch();
        int rowNumSheet = 1;
        //插入图片
        int picNum = 0;
        String[] picName =new String[]{"单体电压折线图","单体内阻折线图","单体温度折线图"};
        String[] picName =getPicName("chr");
        if (picName.length==bytes.size()){
            for(int i=0;i<picName.length;i++){
                sheet.createRow(rowNumSheet-1);
@@ -248,15 +274,39 @@
                rowNumSheet+=30;
            }
        }
        //数据
        RESDataInfo resDataInfo =resService.readFileData(filePath);
        //从文件中获取数据
        List<RESData> list = resDataInfo.resDatas;
        int battNum=list.get(0).getBattSum();//单体个数
        //创建不同sheet
        createBresSheet(wb,battNum,list,1);//创建内阻数据
        createBresSheet(wb,battNum,list,2);//创建温度数据
        createBresSheet(wb,battNum,list,3);//创建电压数据
        XSSFSheet sheet1 = wb.createSheet("数据");
        //抬头
        int rowNum = 0;
        sheet1.createRow(rowNum).createCell(0).setCellValue("测试数据");
        rowNum++;
        //属性栏
        String[] rowName = getRowName("chr");
        XSSFRow row = sheet1.createRow(rowNum);
        for (int i = 0; i < rowName.length; i++) {
            row.createCell(i).setCellValue(rowName[i]);
        }
        for (int i = 0; i < battParam.BattGroupCount; i++) {
            row.createCell(rowName.length + i*2).setCellValue("#" + Integer.valueOf(i + 1)+"在线电压");
            row.createCell(rowName.length + i*2+1).setCellValue("#" + Integer.valueOf(i + 1)+"组端电压");
        }
        rowNum++;
        //数据栏
        for (int i = 0; i < list.size(); i++) {
            sheet1.createRow(rowNum);  //创建行
            Fbs5100FbsData fbsData = list.get(i);
            sheet1.getRow(rowNum).createCell(0).setCellValue(fbsData.testTime.hour+":"+fbsData.testTime.minute+":"+fbsData.testTime.second);
            sheet1.getRow(rowNum).createCell(1).setCellValue(String.valueOf(fbsData.muxianvol_discharge));
            sheet1.getRow(rowNum).createCell(2).setCellValue(String.valueOf(fbsData.muxianvol_charge));
            sheet1.getRow(rowNum).createCell(3).setCellValue(String.valueOf(fbsData.boostDCDC_OutVol));
            sheet1.getRow(rowNum).createCell(4).setCellValue(String.valueOf(fbsData.muxianvol));
            for (int j = 0; j < battParam.BattGroupCount; j++) {
                sheet1.getRow(rowNum).createCell(rowName.length + j*2).setCellValue(String.valueOf(fbsData.onlinevol[j]));
                sheet1.getRow(rowNum).createCell(rowName.length + j*2+1).setCellValue(String.valueOf(fbsData.groupvol[j]));
            }
            rowNum++;
        }
        rowNum++;

        try {
            // 转码防止乱码
            resp.addHeader("Content-Disposition", "attachment;filename="
@@ -272,7 +322,7 @@
        }
    }
    //bres中内阻数据/温度数据/单体电压数据放在不同的sheet中
    public void createBresSheet(XSSFWorkbook wb,int battNum,List<RESData> list,int type){
    /*public void createBresSheet(XSSFWorkbook wb,int battNum,List<RESData> list,int type){
        String sheetName="";
        String testName="";
        switch (type){