bts充电数据导出

whyclxw

2024-12-23 93be23aaba651076443b87e662b0232dd1a03b75

bts充电数据导出

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

@@ -505,7 +505,7 @@
        String volEchart = req.getParameter("vol_echart");            //单体电压折线图
        String currEchart = req.getParameter("curr_echart");        //电池电流折线图
        String groupVolEchart = req.getParameter("groupVol_echart");        //组端电压折线图
        String online_echart = req.getParameter("online_echart");            //在线电压折线图
        String capEchart = req.getParameter("cap_echart");            //测试容量
        String filePath = req.getParameter("filePath");
        //图片base64后的数据
        List<byte[]> bytes = new ArrayList<>();
@@ -522,8 +522,8 @@
                String[] url = groupVolEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(online_echart)) {
                String[] url = online_echart.split(",");
            if (ServletUtils.isNotNull(capEchart)) {
                String[] url = capEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
        }catch (Exception e){
@@ -584,7 +584,7 @@
        rowNumSheet+=4;
        //插入图片
        int picNum = 0;
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","在线电压折线图"};
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","测试容量折线图"};
        if (picName.length==bytes.size()){
            for(int i=0;i<picName.length;i++){
                sheet.createRow(rowNumSheet-1);
@@ -656,7 +656,7 @@
        String volEchart = req.getParameter("vol_echart");            //单体电压折线图
        String currEchart = req.getParameter("curr_echart");        //电池电流折线图
        String groupVolEchart = req.getParameter("groupVol_echart");        //组端电压折线图
        String online_echart = req.getParameter("online_echart");            //在线电压折线图
        String capEchart = req.getParameter("cap_echart");            //测试容量折线图
        String filePath = req.getParameter("filePath");
        //图片base64后的数据
        List<byte[]> bytes = new ArrayList<>();
@@ -673,8 +673,8 @@
                String[] url = groupVolEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(online_echart)) {
                String[] url = online_echart.split(",");
            if (ServletUtils.isNotNull(capEchart)) {
                String[] url = capEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
        }catch (Exception e){
@@ -726,7 +726,7 @@
        rowNumSheet+=4;
        //插入图片
        int picNum = 0;
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","在线电压折线图"};
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","测试容量折线图"};
        if (picName.length==bytes.size()){
            for(int i=0;i<picName.length;i++){
                sheet.createRow(rowNumSheet-1);