修改解析

whyclxw

2024-10-17 77dba770ab6ab03d25106d143b6443d4c77a4af7

修改解析

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

@@ -5,6 +5,8 @@
import com.whyc.pojo.AnaylsisId;
import com.whyc.pojo.AnaysisData;
import com.whyc.pojo.BatttestdataId;
import com.whyc.pojo.UserInf;
import com.whyc.util.ActionUtil;
import com.whyc.util.AnalysisUtil;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
@@ -30,16 +32,16 @@

    //预估数据
    public String createAnaysisXls(int battGroupId, int testRecordCount) {
        UserInf uinf= ActionUtil.getUser();
        String uid=String.valueOf(uinf.getUId());
        //1.查出需要预估的数据
       List<AnaysisData> list=subService.getAnaysisData(battGroupId,testRecordCount);
        String excelName="测试数据.xlsx";
        //String root = FileDirPath.getFileDirName();
        //String excelOutPutPath=root+ File.separator+"outPath";
        String excelName="测试数据"+"_"+battGroupId+"_"+testRecordCount+".xlsx";
        //2.生成解析的xls
        String root=exportDataToXls(excelName,list);
        String root=exportDataToXls(uid,excelName,list);
        String voltagePredictExePath=root+ File.separator+"10小时率电压预估\\voltage_predict_process\\main.exe";
        String excelOutPutPath=root+ File.separator+"outPath";
        String excelSourcePath=root+ File.separator+"测试数据.xlsx";
        String excelOutPutPath=root+ File.separator+"analysis"+File.separator+uid+ File.separator+"outPath"+File.separator+battGroupId+File.separator+testRecordCount;
        String excelSourcePath=root+ File.separator+"analysis"+File.separator+uid+File.separator+excelName;
        //4。将预估的数据存入数据库
        if(list!=null){
            int recordNum=list.size()+1;
@@ -192,7 +194,7 @@
    }

    //生成解析的xls
    private String exportDataToXls( String excelName,List<AnaysisData> list) {
    private String exportDataToXls(String uid, String excelName,List<AnaysisData> list) {
        String fileDirName = FileDirPath.getFileDirName();
        String rootFace="";
        String[] titleNames=new String[]{"时间(HMS)","总电压(V)","总电流(A)","容量(AH)"};
@@ -222,10 +224,15 @@
                cell.setCellValue(j+1+"#");
            }
        }
        rootFace=fileDirName;
        rootFace=fileDirName+File.separator+"analysis";
        File destfile = new File(rootFace);
        if(!destfile.exists()) {
            destfile.mkdir();
        }
        rootFace=fileDirName+File.separator+"analysis"+File.separator+uid;
        File destfile1 = new File(rootFace);
        if(!destfile1.exists()) {
            destfile1.mkdir();
        }
        //将选中的文件存入指定目录下打包下载
        if(list!=null&&list.size()>0){
@@ -262,7 +269,7 @@
                }
            }
        }
        return rootFace;
        return fileDirName;
    }

    //查询预估数据

 src/main/java/com/whyc/util/AnalysisUtil.java

@@ -11,7 +11,7 @@
    String excelOutPutPath = "D:\\10小时率电压预估\\输出目录";*/
    public  static String voltagePredictExePath="E:\\GitWorkSpace\\fg_v2.0\\target\\10小时率电压预估\\voltage_predict_process\\main.exe";
    public  static String excelOutPutPath="E:\\GitWorkSpace\\fg_v2.0\\target\\outPath";
    public  static String excelSourcePath="E:\\GitWorkSpace\\fg_v2.0\\target\\anaysis\\测试数据.xlsx";
    public  static String excelSourcePath="E:\\GitWorkSpace\\fg_v2.0\\target\\测试数据.xlsx";

    public static void analysisXlx(String excelSourcePath,String voltagePredictExePath,String excelOutPutPath){
        Process mProcess;
@@ -70,4 +70,7 @@
        }
    }

    public static void main(String[] args) {
        analysisXlx(excelSourcePath,voltagePredictExePath,excelOutPutPath);
    }
}