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

最新推荐文章于 2024-01-21 22:34:51 发布

经年JN

最新推荐文章于 2024-01-21 22:34:51 发布

阅读量837

点赞数

分类专栏： Java 文章标签： poi

本文链接：https://blog.csdn.net/kxkkl/article/details/42170637

版权

Java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

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