Data_Process.java

于 2022-03-31 15:42:19 发布
阅读量190 收藏
点赞数
文章标签： 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;
}

}

weixin_37936710
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
机器学习之基于文本内容的垃圾短信识别
weixin_46128342的博客
04-21 1万+
机器学习之基于文本内容的垃圾短信识别 1.背景与目标 2.数据探索 3.数据预处理 4.文本的向量表示 5.模型训练与评价 1.背景与目标 我国目前的垃圾短信现状： 垃圾短信黑色利益链 缺乏法律保护 短信类型日益多变 案例目标：垃圾短信识别。 基于短信文本内容，建立识别模型，准确地识别出垃圾短信，以解决垃圾短信过滤问题 2.数据探索 总体流程 数据展示 *观察数据，请思考： 建模前需...
data_process
我想更黑一点
07-12 176
二、split的方法。
[开源工具]被运用到上万个项目中的数据生成器［Data-Processer］ 宣布开源
weixin_34323858的博客
12-16 392
Data-Processer简介 Data-Processer是一个模拟数据生成器。通常在测试过程中，产生完整、全面的真实数据比较困难。Data-Processer可以帮助我们根据需求，创建对应的模版和词典，生成我们需要的模拟数据。此工具由云智慧发布，是一款成熟的模拟数据生成器。已被广泛的运用于全栈性能监控、端到端应用性能管理、全链路性能...
data_process_数据处理_
09-30
一个数据分析样例，常见的基本数据处理思路及方法
多线程编程之嵌套锁
anwu0979的博客
12-08 229
嵌套锁只是针对一种特殊情况而引申出来的锁应用形式而已。 　　参考下面这种应用场合： HANDLE hLock; void sub_func() { WaitForSingleObject(hLock, INFINITE); do_something(); ReleaseMutex(hLock); } void data_proce...
dataProcess.zip
01-20
从一个txt文件读取数据，进行处理，将处理结果写入另一个文件，用于解决大量重复数据人眼没办法看清的情况。资源中的处理过程是我自己文档的处理内容，具体处理过程请根据实际情况修改。本资源对文件读写操作部分...
pro_apache_third_edition..pdf
08-16
Contents About the Author...............................................................................................xix About the Technical Reviewer and Contributing Author.................xxi ...
-pickle.PicklingError: Can't pickle <function... pycharm2023运行报错
06-03
pickle Python多进程程序在pycharm2023运行报错解决
ap6212a0_a33_sc3817r_服务器验证通过_bt已经通了_wifi需要修改配置_需要再次验证_20170626_1549.7z
06-26
# frameworks/native/data/etc/android.hardware.touchscreen.multitouch.jazzhand.xml:system/etc/permissions/android.hardware.touchscreen.multitouch.jazzhand.xml \ # frameworks/native/data/etc/android....
Mastering Java for Data Science
05-04
This book will teach you how to create Data Science applications with Java. First, we will revise the most important things when starting a Data Science application, and then brush up the basics of ...
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
data_process.py
05-20
利用python批量提取复制多个文件夹下的文件，并重命名
模拟数据生成器 Data-Processer
04-24
它是一个模拟数据生成器。我们在测试过程中，产生完整、全面的真实数据可能比较困难。我们可以根据需求，创建对应的模版和词典，利用数据模拟生成器生成我们需要的模拟数据。
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
MATLAB中导入数据：importdata函数
热门推荐
聚沙成塔
11-10 8万+
用load函数导入mat文件大家都会。但是今天我拿到一个数据，文件后缀名居然是‘.data’。该怎么读呢？ 我只好用matlab界面Workspace区域的“import data”按钮手工导入该文件。恩，还好，居然成功了。顺便提一下，这个“import data”按钮功能很强大，连excel文件都能导入。 但是如果在脚本里如何导入这种非mat文件呢？ 这时候就轮到“importdata”函
matlab批量读取处理文件
m0_46483236的博客
04-15 2万+
matlab需要读取一个文件夹下的多个子文件夹中的某种指定格式的文件，该如何批量操作呢？ 首先，先介绍几个matlab中常用的函数 1. dir() 2. length() 3. isequal() 4. fullfile() 参考： https://www.cnblogs.com/smqh-bokeyuan/p/11406549.html https://blog.csdn.net/loadqian/article/details/80656453 https://blog.csd.
DataProcess-数据处理 1.0
klegge的博客
11-01 1963
DataProcess是一款文件操作、数据处理、统计计算和可视作图的数据处理分析软件，集成工程常用多种算法和性能参数，支持大量批处理操作，兼容性强，运行速度快，使用简单便捷。DataProcess特别适用于地理信息处理、设备测试分析、数据统计等方面人员，支持大量批处理和表达式计算，极大提高工作效率。 DataProcess软件特点 1 集成数百种数据统计计算作图方法，涉及数据处理的各个方面。 2 支持大量批文件处理和批配置操作，繁杂工作一键搞定。 3 支持表达...
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、付费专栏及课程。

余额充值