//解析excel文件
String path = "src/main/webapp/importTemplate/template.xls";
FileInputStream fis = new FileInputStream(path);
Workbook workBook = Workbook.getWorkbook(fis);
Sheet sheet = workBook.getSheet(0);
int rows = sheet.getRows();
int columns = sheet.getColumns();
System.out.println("columns-->"+columns);
System.out.println("rows-->"+rows);
for(int i=0; i<rows; i++) {
Cell[] cell = sheet.getRow(i);
for(int j=0; j<columns; j++) {
System.out.print(cell[j].getContents()+" ");
}
System.out.println();
}
相关的包可以到网上去下载