1 public class Demo6 { 2  3     public static void main(String[] args) throws IOException { 4         InputStream is = new FileInputStream("F:\\poi\\name.xls"); 5         POIFSFileSystem fs = new POIFSFileSystem(is); 6         HSSFWorkbook wb = new HSSFWorkbook(fs); 7         HSSFSheet sheet = wb.getSheetAt(0);//获取第一个sheet页 8         if(sheet==null){ 9             return;10         }11         //遍历row12         for(int rowNum = 0; rowNum<=sheet.getLastRowNum();rowNum++ ){13             HSSFRow row = sheet.getRow(rowNum);14             if(row == null){15                 continue;16             }17             //遍历cell18             for (int cellNum = 0; cellNum < row.getLastCellNum(); cellNum++) {19                 HSSFCell cell = row.getCell(cellNum);20                 if(cell == null){21                     continue;22                 }23                 System.out.println(" ");24             }25             System.out.println();26         }27     }28 29     private static String getValue(HSSFCell cell){30         String cellvalue = "";31         switch (cell.getCellType()){32             case HSSFCell.CELL_TYPE_NUMERIC:33                     cellvalue = String.valueOf(cell.getNumericCellValue());34                 break;35             case HSSFCell.CELL_TYPE_STRING:36                     cellvalue = String.valueOf(cell.getStringCellValue());37                 break;38             case HSSFCell.CELL_TYPE_BOOLEAN:39                     cellvalue = String.valueOf(cell.getBooleanCellValue());40                 break;41             case HSSFCell.CELL_TYPE_FORMULA:42                     cellvalue = String.valueOf(cell.getArrayFormulaRange());43                 break;44             default:45                 break;46         }47         return cellvalue;48     }49 }

Exception:            The supplied data appears to be in the Office 2007+ XML. 关键问题的原因还是excel2003和excel2007版本的问题3、解决办法（1）判断文件后缀名是xls，还是xlsx（2）如果是xls，使用HSSFWorkbook；如果是xlsx，使用XSSFWorkbook