POI在Excel中插入图片

最新推荐文章于 2024-09-19 12:03:41 发布

原创最新推荐文章于 2024-09-19 12:03:41 发布 · 697 阅读

0 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

18 篇文章

订阅专栏

本文介绍如何使用Apache POI库在Java应用程序中创建包含图片的Excel文件。通过示例代码展示了从文件读取图片、将图片添加到Excel单元格的过程，并最终保存为.xls格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

POI下载地址

http://www.fayea.com/apache-mirror/poi/release/bin/poi-bin-3.9-20121203.tar.gz

public static void main(String[] args) {
	
	FileOutputStream fileOut = null; 
    BufferedImage bufferImg =null; 
    BufferedImage bufferImg1 = null; 
	try {
		//读取图片
	ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); 
    ByteArrayOutputStream byteArrayOut1 = new ByteArrayOutputStream(); 
    bufferImg = ImageIO.read(new File("e:/nanjing.jpg")); 
    bufferImg1 = ImageIO.read(new File("e:/nanjing.jpg")); 
    ImageIO.write(bufferImg,"jpg",byteArrayOut); 
    ImageIO.write(bufferImg1,"jpg",byteArrayOut1); 
	  //创建excel		 
	HSSFWorkbook excelfile = new HSSFWorkbook();
	HSSFSheet excelsheet=excelfile.createSheet();
	
	excelfile.setSheetName(0, "aaa");
	//设置图片位置
	    HSSFPatriarch patriarch = excelsheet.createDrawingPatriarch(); 
        HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,512,255,(short) 1,1,(short)10,20); 
        HSSFClientAnchor anchor1 = new HSSFClientAnchor(0,0,512,255,(short) 2,30,(short)10,60);       
        patriarch.createPicture(anchor , excelfile.addPicture(byteArrayOut.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));
        patriarch.createPicture(anchor1 , excelfile.addPicture(byteArrayOut1.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG)); 
      //输出到磁盘  
		fileOut = new FileOutputStream("E:/1/t"+System.currentTimeMillis()+".xls");
		excelfile.write(fileOut);
		fileOut.close();
	} catch (FileNotFoundException e) {
		System.out.println(e.getLocalizedMessage());
		
	} catch (IOException e) {
		System.out.println(e.getLocalizedMessage());
		
	}
	}