读取excle文件需要依赖apache公式的POI的jar包,需提交下载好
public static List<String> readExcel(String filePath) throws IOException {
File file = new File(filePath);
XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(file));
Sheet sheet = workbook.getSheetAt(0);
List<String>fileList=new ArrayList<String>();
Row row = null;
int rowCount = sheet.getPhysicalNumberOfRows();
for (int i = 1; i < rowCount; i++) {
row = sheet.getRow(i);
if (row != null) {
int coloumNum = sheet.getRow(0).getPhysicalNumberOfCells();
StringBuffer s=new StringBuffer();
for (int j = 0; j < coloumNum; j++) {
Cell cell = row.getCell(j);
if(cell!=null) {
s.append(cell.toString());
}else {
s.append(" ");
}
if(j!=coloumNum-1)s.append("-");
}
fileList.add(s.toString());
}
}
workbook.close();
return fileList;
}
}