Data_Process.java

最新推荐文章于 2023-12-24 22:31:35 发布
最新推荐文章于 2023-12-24 22:31:35 发布
阅读量240 收藏
点赞数
文章标签： java python 其他
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_37936710/article/details/123873982
版权

Data_Process.java
package com;

import java.util.List;
import java.util.Map;

public class DataProcessing {
public static void main(String[] args) {
String TeamTrackSource = System.getProperty(“C:\wz\Crester\9-20\marked//FEM.xlsx”);
String JiraSource = System.getProperty(“C:\wz\Crester\-20\JIRAxlsx//Jira_FEM_new.xlsx”);
String TargetPath = “C:\wz\Crester”;
// String TeamTrackSource = System.getProperty(“TeamTrackSource”);
// String JiraSource = System.getProperty(“JiraSource”);
// String TargetPath = System.getProperty(“TargetPath”);

    int [] TeamTrack1 = Utils.readTeamTrackFileList(TeamTrackSource,0,5);
    int [] jira1 = Utils.readJiraFileList(JiraSource,0,0);
    List<List> TeamTrackList  = Utils.readTeamTrackFile(TeamTrackSource,0,TeamTrack1);
    List<List>  Jira_List = Utils.readAssignByJiraExcel(JiraSource,0,jira1);
    Map map = MapTest.test2(TeamTrackList,Jira_List);
    //导出数据

// DataEx.Log(“Final Result:”,“C:\wz\Crester”);
// DataEx.Log(“Final Result:”,TargetPath);
System.out.println(map.get(“errorList”));
System.out.println(map.get(“unExistList”));
}
}

Utils.java
package com;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.util.StringUtil;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.;
import java.text.SimpleDateFormat;
import java.util.;

public class Utils {
//读取excel
public static org.apache.poi.ss.usermodel.Workbook readExcel(String filePath) {
org.apache.poi.ss.usermodel.Workbook wb = null;
if (filePath == null) {
return null;
}
String extString = filePath.substring(filePath.lastIndexOf("."));
InputStream is = null;
try {
is = new FileInputStream(filePath);
if (".xls".equals(extString)) {
return wb = new HSSFWorkbook(is);
} else if (".xlsx".equals(extString)) {
return wb = new XSSFWorkbook(is);
// return wb = new SXSSFWorkbook(new XSSFWorkbook(is));
} else {
return wb = null;
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return wb;
}

//获取指定colnum
public static List<List> readAssignByExcel(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum others
public static List<List> readAssignByExcelothers(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows +10; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
if(row1 == null){
continue;
}
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 +10 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum other
public static List<List> readAssignByExcelother(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows + 1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum mayaetl
public static List<List> readAssignByExcelmayaetl(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows +1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum ilevel
public static List<List> readAssignByExcelilevel(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows+1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum icrm
public static List<List> readAssignByExcelicrm(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows+1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1+10 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
if(j == 0){
//去掉0
int o1 = Integer.parseInt(row1.getCell(j).toString());
String stro1 = String.valueOf(o1);
li.add(stro1);
}else {
li.add(row1.getCell(j).toString());
}
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnumibor
public static List<List> readAssignByExcelibor(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows+1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnumica
public static List<List> readAssignByExcelca(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows+1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1+10; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnumifem
public static List<List> readAssignByExcelfem(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows+1; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 +10 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);
} else {
li.add(row1.getCell(j).toString());
}
}
}
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum
public static List<List> readAssignByExcel1(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        int rows = sheet.getPhysicalNumberOfRows();
        Row row = sheet.getRow(0);
        for (int i = 6; i < rows + 1; i++) {
            List<String> li = new ArrayList<>();
            Row row1 = sheet.getRow(i);
            int colnum1 = row1.getPhysicalNumberOfCells();
            for (int j = 0; j < colnum1 + 33; j++) {
                //获取指定列数的值index=0、1、.....
                for (int a1 : a) {
                    if (a1 == j) {
                        if (row1.getCell(j) == null) {
                            li.add("");
                        } else {
                            if(j == 0){
                                int o1 = Integer.parseInt(row1.getCell(j).toString());
                                String stro1 = String.valueOf(o1);
                                li.add(stro1);
                            }else {
                                li.add(row1.getCell(j).toString());
                            }
                        }
                    }
                }

//
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定colnum
public static List<List> readAssignByExcelibor_it(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        int rows = sheet.getPhysicalNumberOfRows();
        Row row = sheet.getRow(0);
        for (int i = 6; i < rows+1; i++) {
            List<String> li = new ArrayList<>();
            Row row1 = sheet.getRow(i);
            int colnum1 = row1.getPhysicalNumberOfCells();
            for (int j = 0; j < colnum1 + 33; j++) {
                //获取指定列数的值index=0、1、.....
                for (int a1 : a) {
                    if (a1 == j) {
                        if (row1.getCell(j) == null) {
                            li.add("");
                        } else {
                            li.add(row1.getCell(j).toString());
                        }
                    }
                }

//
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//获取指定Jira colnum
public static List<List> readAssignByJiraExcel(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        int rows = sheet.getPhysicalNumberOfRows();
        Row row = sheet.getRow(0);
        for (int i = 1; i < rows; i++) {
            List<String> li = new ArrayList<>();
            Row row1 = sheet.getRow(i);
            int colnum1 = row1.getPhysicalNumberOfCells();
            for (int j = 0; j < colnum1 + 33; j++) {
                //获取指定列数的值index=0、1、.....
                for (int a1 : a) {
                    if (a1 == j) {
                        if (row1.getCell(j) == null) {
                            li.add("");
                        } else {
                            li.add(rvZeroAndDot(row1.getCell(j).toString()));
                        }
                    }
                }

//
}
list.add(li);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}

//去掉小数点后多余的零
public static String rvZeroAndDot(String s) {
    if (s.isEmpty()) {
        return null;
    }
    if (s.indexOf(".") > 0) {
        s = s.replaceAll("0+?$", "");//去掉多余的0
        s = s.replaceAll("[.]$", "");//如最后一位是.则去掉
    }
    return s;
}

//找差集 FindDiff
public static List findDiff(List list, List list1) {
    List arrList = new ArrayList();
    for(int i = 0; i < list.size(); i++) {
        int o = 0;
        String str = list.get(i).toString();
        for(int j = 0; j < list1.size(); j++){
            String str1 = list1.get(j).toString();
            if(str.equals(str1)){
                o=o+1;
            }
        }
        if(o == 0){
            arrList.add(str);
        }
    }
    return arrList;
}

//找交集 intersection
public static List<List> findIntersection( List<List> list1,List list) {
    List<List> arrList = new ArrayList();
    for(int i = 0; i < list1.size(); i++) {
        for(int j = 0; j < list.size(); j++){
            if(list.get(i).toString().equals(list1.get(j).get(7))){
                arrList.add(list1.get(i));
            }
        }
    }
    return arrList;
}

//获取指定colnum others
public static List<List> readTeamTrackFile(String file, int index, int[] a) {
    List<List> list = new ArrayList<>();

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println(“col2 : “+col2);
Row row = sheet.getRow(0);
for (int i = 6; i < rows +10; i++) {
List li = new ArrayList<>();
Row row1 = sheet.getRow(i);
if(row1 == null){
continue;
}
int colnum1 = row1.getPhysicalNumberOfCells();
for (int j = 0; j < colnum1 +10 ; j++) {
//获取指定列数的值index=0、1、…
for (int a1 : a) {
if (a1 == j) {
if (row1.getCell(j) == null) {
li.add(””);

                        } else {
                            if(j == 0){
                                //去掉0
                                int o1 = Integer.parseInt(row1.getCell(j).toString());
                                String stro1 = String.valueOf(o1);
                                li.add(stro1);
                            }else {
                                li.add(row1.getCell(j).toString());
                            }
                        }
                    }
                }
            }
            list.add(li);
        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return list;
}

//获取TeamTrack colnum 数组
public static int [] readTeamTrackFileList(String file, int index,int a) {
    List<List> list = new ArrayList<>();
    int [] temp = new int[8];

// List list2= new ArrayList();
try {
org.apache.poi.ss.usermodel.Sheet sheet = null;
org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
sheet = wb.getSheetAt(index);
int rows = sheet.getPhysicalNumberOfRows();
// System.out.println(rows);
// int col2= sheet.getLastRowNum();
// System.out.println("col2 : "+col2);
Row row = sheet.getRow(a);
int colnum1 = row.getPhysicalNumberOfCells();

            for (int j = 0; j < colnum1+10 ; j++) {
                //获取指定列数的值index=0、1、.....
                if(row.getCell(j)==null){
                    break;
                }
                if (row.getCell(j).toString().equals("Item Id")) {
                    System.out.println(row.getCell(j).toString());
                    temp [0]=j;
                }
                if (row.getCell(j).toString().equals("Title")) {
                    System.out.println(row.getCell(j).toString());
                    temp [1]=j;
                }
                if (row.getCell(j).toString().equals("Assigned To")) {
                    System.out.println(row.getCell(j).toString());
                    temp [2]=j;
                }
                if (row.getCell(j).toString().equals("Country")) {
                    System.out.println(row.getCell(j).toString());
                    temp [3]=j;
                }
                if (row.getCell(j).toString().equals("Item Type")) {
                    System.out.println(row.getCell(j).toString());
                    temp [4]=j;
                }
                if (row.getCell(j).toString().equals("Last Modified Date")) {
                    System.out.println(row.getCell(j).toString());
                    temp [5]=j;
                }
                if (row.getCell(j).toString().equals("Severity")) {
                    System.out.println(row.getCell(j).toString());
                    temp [6]=j;
                }
                if (row.getCell(j).toString().equals("Submitter")) {
                    System.out.println(row.getCell(j).toString());
                    temp [7]=j;
                }
            }


    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return temp;
}

//获取TeamTrack colnum 数组 两个字段
public static int [] readTeamTrackFileList2(String file, int index,int a) {
    List<List> list = new ArrayList<>();
    int [] temp = new int[2];
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        Row row = sheet.getRow(a);
        int colnum1 = row.getPhysicalNumberOfCells();
        for (int j = 0; j < colnum1+10 ; j++) {
            //获取指定列数的值index=0、1、.....
            if(row.getCell(j)==null){
                continue;
            }
            if (row.getCell(j).toString().equals("Item Id")) {

// System.out.println(row.getCell(j).toString());
temp [0]=j;
}
if (row.getCell(j).toString().equals(“Title”)) {
// System.out.println(row.getCell(j).toString());
temp [1]=j;
}
}

    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return temp;
}

//获取TeamTrack colnum 数组
public static int [] readJiraFileList (String file, int index,int a) {
    List<List> list = new ArrayList<>();
    int [] temp = new int[8];
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        int rows = sheet.getPhysicalNumberOfRows();
        Row row = sheet.getRow(a);
        int colnum1 = row.getPhysicalNumberOfCells();
        for (int j = 0; j < colnum1+10 ; j++) {
            //获取指定列数的值index=0、1、.....
            if(row.getCell(j)==null){
                break;
            }

            if (row.getCell(j).toString().equals("Summary")) {
                System.out.println(row.getCell(j).toString());
                temp [0]=j;
            }
            if (row.getCell(j).toString().equals("Invest_report_itemtype")) {
                System.out.println(row.getCell(j).toString());
                temp [1]=j;
            }
            if (row.getCell(j).toString().equals("Severity")) {
                System.out.println(row.getCell(j).toString());
                temp [2]=j;
            }
            if (row.getCell(j).toString().equals("Updated")) {
                System.out.println(row.getCell(j).toString());
                temp [3]=j;
            }
            if (row.getCell(j).toString().equals("TT_Assignee")) {
                System.out.println(row.getCell(j).toString());
                temp [4]=j;
            }
            if (row.getCell(j).toString().equals("TT_Country")) {
                System.out.println(row.getCell(j).toString());
                temp [5]=j;
            }
            if (row.getCell(j).toString().equals("TT_Submitter")) {
                System.out.println(row.getCell(j).toString());
                temp [6]=j;
            }
            if (row.getCell(j).toString().equals("Team Track ID")) {
                System.out.println(row.getCell(j).toString());
                temp [7]=j;
            }

        }


    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return temp;
}

//获取TeamTrack colnum 数组 2
public static int [] readJiraFileList2 (String file, int index,int a) {
    List<List> list = new ArrayList<>();
    int [] temp = new int[2];
    try {
        org.apache.poi.ss.usermodel.Sheet sheet = null;
        org.apache.poi.ss.usermodel.Workbook wb = readExcel(file);
        sheet = wb.getSheetAt(index);
        Row row = sheet.getRow(a);
        int colnum1 = row.getPhysicalNumberOfCells();
        for (int j = 0; j < colnum1+10 ; j++) {
            //获取指定列数的值index=0、1、.....
            if(row.getCell(j)==null){
                continue;
            }
            if (row.getCell(j).toString().equals("Summary")) {

// System.out.println(row.getCell(j).toString());
temp [0]=j;
}
if (row.getCell(j).toString().equals(“Team Track ID”)) {
// System.out.println(row.getCell(j).toString());
temp [1]=j;
}

        }


    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return temp;
}

}

Android上app_process启动java进程
Venscor技术养成之路
11-14 3万+
Java程序是跨平台的，由JVM虚拟机执行字节码。Android应用程序开发也是Java，但是都是运行在Context环境下的。独立的Java程序能够在Android上独立运行？  这里不介绍Android启动过程中，app_process从哪个进程fork处理，也不介绍app_process启动App的过程。仅介绍app_process启动纯Java程序的相关知识。一、HelloWorld示例1.
Node child_process的fork，spawn，exec我有话要说
热门推荐
小辣抓
11-29 1万+
Node child_process的fork，spawn，exec我有话要说node的异步io处理方式是众所周知的，io越密集，node 的优势就越明显，但是node是单线程的，不能像java那种多线程语言一样开启一些worker thread，充分利用cpu资源，提高计算效率和操作系统的吞吐量，但是node依然给我们提供了child_process让我们可以创建子进程来充分的利用cpu资源，让n
data_process_数据处理_
09-30
一个数据分析样例，常见的基本数据处理思路及方法
data_process
我想更黑一点
07-12 274
二、split的方法。
data_process.py
05-20
利用python批量提取复制多个文件夹下的文件，并重命名
[开源工具]被运用到上万个项目中的数据生成器［Data-Processer］ 宣布开源
weixin_34323858的博客
12-16 443
Data-Processer简介 Data-Processer是一个模拟数据生成器。通常在测试过程中，产生完整、全面的真实数据比较困难。Data-Processer可以帮助我们根据需求，创建对应的模版和词典，生成我们需要的模拟数据。此工具由云智慧发布，是一款成熟的模拟数据生成器。已被广泛的运用于全栈性能监控、端到端应用性能管理、全链路性能...
dplyr_DataProcess
lswbjtu的博客
05-11 1182
讲解dplyr包在数据处理中的使用，此包将原本plyr包中的ddply()等函数进一步分离强化, 专注接受 ‘dataframe’对象, 大幅提高了处理数据的速度, 并且提供了更稳健的与其它数据库对象间的接口。
利用app_process实现免root调用shell_Java_下载.zip
04-26
下面我们将详细探讨如何利用`app_process`来实现这一目标，以及在Java中如何进行相关操作。 首先，`app_process`是Android系统中的一个可执行文件，它位于系统的`/system/bin`目录下，用于启动一个应用程序的主进程...
db_data_process
03-03
"db_data_process"这个项目很可能是一个关于使用Scala语言进行数据库数据处理的开源项目。Scala是一种强大的编程语言，它结合了面向对象和函数式编程的特性，尤其适合处理大规模数据。 首先，我们需要了解Scala的...
Java语言程序设计基础篇课后题答案-Chapter18BinaryI_O.pdf
11-08
They extend the `InputStream` and `OutputStream` classes respectively, which form the base for all input and output streams in Java. 13. To read a binary file using `FileInputStream`, you would ...
dataProcess.zip
01-20
从一个txt文件读取数据，进行处理，将处理结果写入另一个文件，用于解决大量重复数据人眼没办法看清的情况。资源中的处理过程是我自己文档的处理内容，具体处理过程请根据实际情况修改。本资源对文件读写操作部分比较通用，具有参考价值。 文件处理接口包括：fopen、fclose、fread、rewind、fgetc、fgets、fprintf、fgetpos 涉及功能包括：文件打开、文件关闭、文件读取、文件写入、回到文件头、指定文件行数等
Python库 | data_process-0.1.29-py2.py3-none-any.whl
03-28
资源分类：Python库 所属语言：Python 资源全名：data_process-0.1.29-py2.py3-none-any.whl 资源来源：官方 安装方法：https://lanzao.blog.csdn.net/article/details/101784059
JsonDateValueProcessor.java
09-06
用与转化Json Date的工具类。具体使用方法见我的博客！
Python库 | data-process-0.1.14.tar.gz
04-07
资源分类：Python库 所属语言：Python 资源全名：data-process-0.1.14.tar.gz 资源来源：官方 安装方法：https://lanzao.blog.csdn.net/article/details/101784059
DataProcess-数据处理 1.0
klegge的博客
11-01 2095
DataProcess是一款文件操作、数据处理、统计计算和可视作图的数据处理分析软件，集成工程常用多种算法和性能参数，支持大量批处理操作，兼容性强，运行速度快，使用简单便捷。DataProcess特别适用于地理信息处理、设备测试分析、数据统计等方面人员，支持大量批处理和表达式计算，极大提高工作效率。 DataProcess软件特点 1 集成数百种数据统计计算作图方法，涉及数据处理的各个方面。 2 支持大量批文件处理和批配置操作，繁杂工作一键搞定。 3 支持表达...
DataProcess-语义分割数据集中将原始数据划分为73比例
最新发布
dejahu的博客
12-24 606
【代码】DataProcess-语义分割数据集中将原始数据划分为73比例。
[数据处理记录]little_data_process2016
panbaoran913的博客
01-23 1322
一、小数据点 数据一：[13098, 11129, 11105, 11157, 11021, 11018, 11028, 11157]网状 数据二：[11194, 15090, 11018, 11028, 11009, 15076, 11147, 11105]星状 数据三：[11106, 15018, 11020, 11012, 11018, 11212, 11016, 11014]网状 数据四：[11131, 11194, 11106, 11012, 15018, 11228, 11013, 11014
JDK: Date Process
难得糊涂
03-15 828
序言 整理下JDK8以后针对时间的加强处理
child_process调用java
07-28
const javaProcess = spawn('java', ['-jar', 'path/to/your/java.jar', 'arg1', 'arg2']); // 监听Java程序的输出 javaProcess.stdout.on('data', (data) => { console.log(`输出：${data}`); }); // 监听Java...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值