文件解析告警数据导出

lxw

2023-05-17 30997c6371023d0d197a5a16d317c33a0832f316

文件解析告警数据导出

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

@@ -93,7 +93,7 @@
        rowNumSheet++;
        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);
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("测试时长：" + getHHMMSS(capState.Test_Time.hour,capState.Test_Time.minute,capState.Test_Time.second));

        rowNumSheet += 4;
        //插入图片
@@ -132,7 +132,7 @@
        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(0).setCellValue(getHHMMSS(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));
@@ -163,6 +163,27 @@
    //将日期格式转换成指定的字符串格式
    public static String formartDate(Date date, String str){
        return new SimpleDateFormat(str).format(date);
    }

    //获取标准格式时间
    public static String getHHMMSS(int hour,int minute,int second){
        String time="";
        if(hour<10){
            time+="0"+hour;
        }else{
            time+=""+hour;
        }
        if(minute<10){
            time+=":"+"0"+minute;
        }else{
            time+=":"+minute;
        }
        if(second<10){
            time+=":"+"0"+second;
        }else{
            time+=":"+second;
        }
        return time;
    }
    public String[] getRowName(String bcp){
        if (bcp.equals("bcp")){
@@ -253,7 +274,7 @@
        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);
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("测试时长：" + getHHMMSS(chargeState.Test_Time.hour,chargeState.Test_Time.minute,chargeState.Test_Time.second));

        rowNumSheet += 4;
        //图片元素
@@ -293,7 +314,7 @@
        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(0).setCellValue(getHHMMSS(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));