public static ArrayList read_xlsx(String path_sour, String path_end) {
ArrayList al = new ArrayList();
//String strPath = "c://22.xlsx";
XSSFWorkbook xwb = null;
try {
xwb = new XSSFWorkbook(path_sour);
//
XSSFSheet sheet = xwb.getSheetAt(0);
// row、cell
XSSFRow row = null;
@SuppressWarnings("unused")
String cell = "";
//
int row_num_1 = sheet.getFirstRowNum();
int row_num_end = sheet.getLastRowNum();
//System.out.println(sheet.getPhysicalNumberOfRows());
for (int i = row_num_1; i < row_num_end; i++) {
row = sheet.getRow(i);
// for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) {
// // row.getCell(j).toString() ,
// cell = row.getCell(j).toString();
// System.out.print(cell + "\t");
// }
// row.getCell(j).toString()
if (row.getCell(1).toString().equals("")) {
// break;
} else {
String[] str = new String[2];
// cell = row.getCell(1).toString();
// cell = row.getCell(2).toString();
str[0] = row.getCell(1).toString();
str[1] = path_end + row.getCell(2).toString();
al.add(str);
}
// System.out.print(cell + "\t");
}
for (int i = 0; i < al.size(); i++) {
System.out.println(((String[]) al.get(i))[0]);
}
} catch (IOException e) {
e.printStackTrace();
}
return al;
}