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 "";
?}
?
?
?
?
