poi解析Excel

实例地址：http://download.csdn.net/detail/ht_00001/9520917

--加载Excel

FileInputStream file = new FileInputStream(path);
Workbook wb = null;
if (path.endsWith(".xls")) {
wb = new HSSFWorkbook(file);
} else if (path.endsWith(".xlsx")) {
wb = new XSSFWorkbook(file);
}

--读取sheet

Sheet sheet = wb.getSheetAt(0);

-- 获取最后行 从0开始计数
int lastRow = sheet.getLastRowNum();

--获取取行
 Row row = sheet.getRow(i);

--获取列

Cell cell = row.getCell(j);

--读取列

switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
mess = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_NUMERIC:
if (DateUtil.isCellInternalDateFormatted(cell)) {
mess = cell.getDateCellValue().getTime();
} else {
mess = cell.getNumericCellValue();
}
break;
case Cell.CELL_TYPE_BOOLEAN:
mess = cell.getBooleanCellValue();
break;
case Cell.CELL_TYPE_FORMULA:
mess = cell.getCellFormula();
break;
case Cell.CELL_TYPE_BLANK:
mess = cell.getRichStringCellValue();
break;
case Cell.CELL_TYPE_ERROR:
mess = cell.getErrorCellValue();
break;
}