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);//增加用户 } } } }