POI 3.7 读取xls和xlsx

/**
     * 读取xlsx文档列
     * */
   private String getXSSFCellValue(XSSFCell cell)throws Exception
   {
	   String cellvalue = "";
	   if (cell!=null) {
		   switch (cell.getCellType()) {
		       case XSSFCell.CELL_TYPE_BOOLEAN:
		           cellvalue = String.valueOf(cell.getBooleanCellValue());
		           break;
		       case XSSFCell.CELL_TYPE_NUMERIC:
		    	   cellvalue = String.valueOf(cell.getNumericCellValue());
		           break;
		       case XSSFCell.CELL_TYPE_STRING:
		    	   cellvalue = cell.getStringCellValue();
		           break;
		       case XSSFCell.CELL_TYPE_BLANK:
		           break;
		       case XSSFCell.CELL_TYPE_ERROR:
		           break;
		       case XSSFCell.CELL_TYPE_FORMULA: 
		           break;
		   }
		}
	   return cellvalue;
   }
   /**
    * 读取xls文档列
    * */
   private String getHSSFCellValue(HSSFCell cell)throws Exception
   {
	   String cellvalue = "";
	   if(cell!=null){
		   switch (cell.getCellType()) {
		       case HSSFCell.CELL_TYPE_BOOLEAN:
		           cellvalue = String.valueOf(cell.getBooleanCellValue());
		           break;
		       case HSSFCell.CELL_TYPE_NUMERIC:
		    	   cellvalue = String.valueOf(cell.getNumericCellValue());
		           break;
		       case HSSFCell.CELL_TYPE_STRING:
		    	   cellvalue = cell.getStringCellValue();
		           break;
		       case HSSFCell.CELL_TYPE_BLANK:
		           break;
		       case HSSFCell.CELL_TYPE_ERROR:
		           break;
		       case HSSFCell.CELL_TYPE_FORMULA: 
		           break;
		   }
	   }
	   return cellvalue;
   }
   /**
    * xlsx文档
    * @return 错误提示类型 0-正常 1-存在不能为空的列 2-格式不对 3-空文件
    * */
	private int readXlsx(List<XXDto> list,InputStream inputstream) throws Exception {
		int errType = 0;
		XSSFWorkbook hssfworkbook = new XSSFWorkbook(inputstream);
		XSSFSheet hssfsheet = hssfworkbook.getSheetAt(0);// 第一个工作表
		if (hssfsheet != null) {
			int totalrows = hssfsheet.getPhysicalNumberOfRows();// --获取sheet总行数
			if (totalrows > 1)// 除了标题外，必须有数据
			{
				for (int i = 1; i < totalrows; i++) {
					XSSFRow hssfrow = hssfsheet.getRow(i);
					
				}
			}
			else{
				//--空excel，或者没有数据行的excel
				errType = 3;
			}
		}
		return errType;
	}

/**
     * xls文档
     * @return 错误提示类型 0-正常 1-存在不能为空的列 2-格式不对 3-空文件
     * */
	private int readXlsKpiYear(List<XXDto> list,InputStream inputstream) throws Exception {
		int errType = 0;
		HSSFWorkbook hssfworkbook = new HSSFWorkbook(inputstream);
		HSSFSheet hssfsheet = hssfworkbook.getSheetAt(0);// 第一个工作表
		if (hssfsheet != null) {
			int totalrows = hssfsheet.getPhysicalNumberOfRows();// --获取sheet总行数
			if (totalrows > 1)// 除了标题外，必须有数据
			{
				for (int i = 1; i < totalrows; i++) {
					HSSFRow hssfrow = hssfsheet.getRow(i);
					
				}
			}else{
				//--空excel，或者没有数据行的excel
				errType = 3;
			}
		}
		return errType;
	}