读取exel文件

/**
* @return Map<第i行,Map<第j列,第i行j列的值>>
* @throws Exception
*/
public Map<Integer,Map<Integer,String>> readExcel() throws Exception{
Map<Integer,Map<Integer,String>> exelValues = new HashMap<Integer,Map<Integer,String>>();
String path = getClass().getClassLoader().getResource("janson/test/test.xls").getPath();
File file = new File(path);
FileInputStream fis = new FileInputStream(file);
Workbook workBook = null;
if(typeOfExcel(path) == 1){
workBook = new HSSFWorkbook(fis);//2003 xls
} else if(typeOfExcel(path) == 2){
workBook = new XSSFWorkbook(fis);//2007 xlsx
}
Sheet sheet = workBook.getSheetAt(0);//sheet1 sheet2 sheet3
//sheet = workBook.getSheet("Sheet1"); //等价于上一句
for (int i = 0; i <= sheet.getLastRowNum(); i++) {//遍历所以的行
Map<Integer,String> rowValues = new HashMap<Integer,String>();
Row row = sheet.getRow(i);//取得第i行的数据
for (int j = 0; j < row.getLastCellNum(); j++) {//遍历所有的列
Cell cell = row.getCell(j);//取得第i行j列的元素
if(cell.getCellType() == 0){//数字类型
rowValues.put(j, String.valueOf(cell.getNumericCellValue()));//第i行j列的值
} else if(cell.getCellType() == 1){//字符串类型
rowValues.put(j, cell.getStringCellValue());//第i行j列的值
} else if(cell.getCellType() == 3) {
//...
}
}
exelValues.put(i, rowValues);
}
return exelValues;
}

/**
* 判断exel的类型，如果后缀是xls则返回1，如果后缀是xlsx则返回0，否则返回0
* @param path
* @return
*/
public int typeOfExcel(String path){
if(path == null ||"".equals(path)){
return 0;
}
if(path.endsWith(".xls")){
return 1;
} else if(path.endsWith(".xlsx")){
return 2;
} else {
return 0;
}
}