Java中利用POI操作Excel（支持2003、2007）

Java中POI操作Excel（支持2003、2007）

/** * 仅支持2003 *  * @param file * @throws IOException */private static void readExcel2003(File file) throws IOException {//InputStream is = new FileInputStream(file);//Workbook rwb = new HSSFWorkbook(is);//Sheet sheet = rwb.getSheetAt(0);//Row row = sheet.getRow(3);//Cell cell = row.getCell(0);//System.out.println(cell.getStringCellValue());}/** * 仅支持2007 *  * @param file * @throws IOException */private static void readExcel2007(File file) throws IOException {//InputStream is = new FileInputStream(file);//Workbook rwb = new XSSFWorkbook(is);//Sheet sheet = rwb.getSheetAt(0);//Row row = sheet.getRow(3);//Cell cell = row.getCell(0);//System.out.println(cell.getStringCellValue());}/** * 支持2003/2007 *  * @param file * @throws Exception */private static void readExcel(File file) throws Exception {//InputStream is = new FileInputStream(file);//Workbook rwb = WorkbookFactory.create(is);//Sheet sheet = rwb.getSheetAt(0);//Row row = sheet.getRow(3);//Cell cell = row.getCell(0);//System.out.println(cell.getStringCellValue());}

注：涉及jar包

    poi-3.10-FINAL-20140208.jar
    poi-examples-3.10-FINAL-20140208.jar
    poi-excelant-3.10-FINAL-20140208.jar
    poi-ooxml-3.10-FINAL-20140208.jar
    poi-ooxml-schemas-3.10-FINAL-20140208.jar
    poi-scratchpad-3.10-FINAL-20140208.jar

jar包下载地址

http://download.csdn.net/detail/kaixinkuaikuailai/8304779

源码地址

http://download.csdn.net/detail/kaixinkuaikuailai/8304805