java读Excel2003和2007
首先要去http://poi.apache.org/download.html下载poi包 下最新的就可以。
附件里也有，是3.9版本的。可以读取2003 和2007的excel.具体的代码在下面.

public static void importUser(File file,UserService userService) throws Exception{        if(file.getName().endsWith("xlsx")){            importUser2007(file,userService);        }else if (file.getName().endsWith("xls")){            importUser2003(file,userService);        }    }

private static void importUser2003(File file,UserService userService) throws Exception{        FileInputStream fs = null;        try {            fs = new FileInputStream(file);        } catch (FileNotFoundException e) {            e.printStackTrace();            return;        }        // 创建对Excel工作簿文件的引用        HSSFWorkbook workbook = ExcelTool.getWorkbook(fs);        //获取sheet数        int sheetNum = ExcelUtils.getNumberOfSheets(workbook);        /**         * 遍历excle的每一个工作薄         */        for (int numSheets = 0; numSheets < sheetNum; numSheets++) {            if (null != workbook.getSheetAt(numSheets)) {                //获得一个sheet                HSSFSheet aSheet = ExcelTool.getSheetAt(workbook, numSheets);                int lastRowNum = ExcelUtils.getLastRowNum(aSheet);                if(lastRowNum == 0)continue;                int startRow = 2;//第一行是行头,所以直接取第二行                for (int rowNumOfSheet = startRow; rowNumOfSheet <= lastRowNum; rowNumOfSheet++) {                    User user = new User();                    HSSFRow aRow = aSheet.getRow(rowNumOfSheet);                    String name = "" ;                    HSSFCell docIdCell = ExcelTool.getCell(aRow, 0);                    if (null != docIdCell) {                        String cellStrValue = ExcelUtils.getCellStrValue(docIdCell);                        name = cellStrValue;                    }                    user.setName(name);                    String age = "0";                    HSSFCell ageCell = ExcelTool.getCell(aRow, 1);                    if (null != ageCell) {                        String cellStrValue = ExcelUtils.getCellStrValue(ageCell);                        age = cellStrValue;                    }                    userService.addUser(user);//增加用户                }            }        }    }

private static void importUser2007(File file,UserService userService) throws Exception{        FileInputStream fs = null;        try {            fs = new FileInputStream(file);        } catch (FileNotFoundException e) {            e.printStackTrace();            return;        }        // 创建对Excel工作簿文件的引用        XSSFWorkbook workbook = new XSSFWorkbook(fs);        //获取sheet数        int sheetNum = ExcelUtils.getNumberOfSheets(workbook);        /**         * 遍历excle的每一个工作薄         */        for (int numSheets = 0; numSheets < sheetNum; numSheets++) {            if (null != workbook.getSheetAt(numSheets)) {                //获得一个sheet                XSSFSheet aSheet = workbook.getSheetAt(numSheets);                int lastRowNum = ExcelUtils.getLastRowNum(aSheet);                if(lastRowNum == 0)continue;                int startRow = 2;//第一行是行头,所以直接取第二行                for (int rowNumOfSheet = startRow; rowNumOfSheet <= lastRowNum; rowNumOfSheet++) {                    User user = new User();                    XSSFRow aRow = aSheet.getRow(rowNumOfSheet);                    String name = "" ;                    XSSFCell docIdCell = aRow.getCell(0);                    if (null != docIdCell) {                        String cellStrValue = ExcelUtils.getCellStrValue(docIdCell);                        name = cellStrValue;                    }                    user.setName(name);                    String age = "0";                    XSSFCell ageCell = aRow.getCell(1);                    if (null != ageCell) {                        String cellStrValue = ExcelUtils.getCellStrValue(ageCell);                        age = cellStrValue;                    }                    userService.addUser(user);//增加用户                }            }        }    }