POI 如何读取EXcel表，之后如何存入List集合中

Question

FileInputStream fis = new FileInputStream(
"E:\215e_2016-11-28-15-06-00.xls");
HSSFWorkbook wb = new HSSFWorkbook(fis);
System.out.println(wb);
// 获取整个excel有多少个sheet
HSSFSheet sheet = wb.getSheetAt(0);
System.out.println(sheet);
// 总行数
int rowNum = sheet.getPhysicalNumberOfRows();
System.out.println(rowNum);
// 第一行
int sheetCount = wb.getNumberOfSheets();
System.out.println(sheetCount);
for (int i = 0; i < sheetCount; i++) {
sheet = wb.getSheetAt(i);
rowNum = sheet.getPhysicalNumberOfRows();
int cellNum = sheet.getRow(0).getPhysicalNumberOfCells();
for (int j = 0; j < rowNum; j++) {
HSSFRow row = sheet.getRow(j);
System.out.println(row);
for (short k = 0; k < cellNum; k++) {
HSSFCell cell = row.getCell(k);
System.out.println(cell);
if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
System.out.println(cell.getStringCellValue());
} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
System.out.println(cell.getNumericCellValue());
} else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) {
System.out.println(cell.getBooleanCellValue());
} else if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
System.out.println("NULL");
} else {
System.out.println(cell.getDateCellValue());
}
}
}
}
}

Answer 1

http://www.cnblogs.com/hongten/p/java_poi_excel.html