poi读取xlsx和xls

使用poi读取，jxl对于excel2007不支持

?

1. 读取xlsx 数据

??? InputStream fs?
?

???XSSFWorkbook workbook = new XSSFWorkbook(fs);
???XSSFSheet st = workbook.getSheetAt(0);

???for (int rowNumOfSheet = 1; rowNumOfSheet <= st.getLastRowNum(); rowNumOfSheet++) {
????if (null != st.getRow(rowNumOfSheet)) {
?????XSSFRow aRow = st.getRow(rowNumOfSheet); // 获得一个行

?????int cols = 0;
?????CarData carData = new CarData();
?????carData.setProvince(getCellXlsx(aRow.getCell(++cols)));

??? }

? }

?

?

public String getCellXlsx(XSSFCell cell) {
??if (cell == null)
???return "";

??switch (cell.getCellType()) {
??case XSSFCell.CELL_TYPE_NUMERIC:
???if (HSSFDateUtil.isCellDateFormatted(cell)) {
????Date d = cell.getDateCellValue();
????return formater.format(d);
???} else {
????return df.format(cell.getNumericCellValue());
???}
??case XSSFCell.CELL_TYPE_STRING:
???return cell.getStringCellValue();
??case XSSFCell.CELL_TYPE_FORMULA:
???return cell.getCellFormula();
??case XSSFCell.CELL_TYPE_BLANK:
???return "";
??case XSSFCell.CELL_TYPE_BOOLEAN:
???return cell.getBooleanCellValue() + "";
??case XSSFCell.CELL_TYPE_ERROR:
???return cell.getErrorCellValue() + "";
??}
??return "";
?}

?

2.读取xls 数据

?? HSSFWorkbook workbook = new HSSFWorkbook(fs);
???HSSFSheet st = workbook.getSheetAt(0);

???for (int rowNumOfSheet = 1; rowNumOfSheet <= st.getLastRowNum(); rowNumOfSheet++) {
????if (null != st.getRow(rowNumOfSheet)) {
?????HSSFRow aRow = st.getRow(rowNumOfSheet); // 获得一个行

?????int cols = 0;
?????CarData carData = new CarData();
?????carData.setProvince(getCell(aRow.getCell(++cols)));
????}

?? }

?

public String getCell(HSSFCell cell) {
??if (cell == null)
???return "";
??switch (cell.getCellType()) {
??case HSSFCell.CELL_TYPE_NUMERIC:
???if (HSSFDateUtil.isCellDateFormatted(cell)) {
????Date d = cell.getDateCellValue();
????return formater.format(d);
???} else {
????return df.format(cell.getNumericCellValue());
???}
??case HSSFCell.CELL_TYPE_STRING:
???return cell.getStringCellValue();
??case HSSFCell.CELL_TYPE_FORMULA:
???return cell.getCellFormula();
??case HSSFCell.CELL_TYPE_BLANK:
???return "";
??case HSSFCell.CELL_TYPE_BOOLEAN:
???return cell.getBooleanCellValue() + "";
??case HSSFCell.CELL_TYPE_ERROR:
???return cell.getErrorCellValue() + "";
??}
??return "";
?}

?

?

?

?