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