bts充电数据导出

whyclxw

2024-12-23 7f2ce3666b84df58899527815a5151dd622d5b74

bts充电数据导出

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

@@ -507,6 +507,7 @@
        String groupVolEchart = req.getParameter("groupVol_echart");        //组端电压折线图
        String capEchart = req.getParameter("cap_echart");            //测试容量
        String filePath = req.getParameter("filePath");
        String tmpEchart = req.getParameter("tmp_echart");            //单体温度折线图
        //图片base64后的数据
        List<byte[]> bytes = new ArrayList<>();
        try {
@@ -526,6 +527,10 @@
                String[] url = capEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(tmpEchart)) {
                String[] url = tmpEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
        }catch (Exception e){
            e.printStackTrace();
        }
@@ -539,8 +544,7 @@
        BTS_CapState btscapState=disData.capState;//放电时长
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet("数据总表");
        //图片元素
        XSSFDrawing patriarch = sheet.createDrawingPatriarch();

        int rowNumSheet = 0;
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("电池参数:");
@@ -584,7 +588,9 @@
        rowNumSheet+=4;
        //插入图片
        int picNum = 0;
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","测试容量折线图"};
        //图片元素
        XSSFDrawing patriarch = sheet.createDrawingPatriarch();
        String[] picName =new String[]{"单体电压折线图","电池电流折线图","组端电压折线图","测试容量折线图","单体温度折线图"};
        if (picName.length==bytes.size()){
            for(int i=0;i<picName.length;i++){
                sheet.createRow(rowNumSheet-1);
@@ -658,6 +664,7 @@
        String groupVolEchart = req.getParameter("groupVol_echart");        //组端电压折线图
        String capEchart = req.getParameter("cap_echart");            //测试容量折线图
        String filePath = req.getParameter("filePath");
        String tmpEchart = req.getParameter("tmp_echart");            //单体温度折线图
        //图片base64后的数据
        List<byte[]> bytes = new ArrayList<>();
        try {
@@ -675,6 +682,10 @@
            }
            if (ServletUtils.isNotNull(capEchart)) {
                String[] url = capEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
            if (ServletUtils.isNotNull(tmpEchart)) {
                String[] url = tmpEchart.split(",");
                bytes.add(new BASE64Decoder().decodeBuffer(url[1]));
            }
        }catch (Exception e){
@@ -726,7 +737,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);