POI插入图片到excel

最新推荐文章于 2024-06-27 11:22:00 发布

原创最新推荐文章于 2024-06-27 11:22:00 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

java POI EXCEL 图片专栏收录该内容

1 篇文章

订阅专栏

本文提供了一个使用Java将图像文件插入到Excel指定位置并调整大小的示例代码。通过HSSFWorkbook、HSSFPatriarch等类实现了图像的导入及自适应。此代码适用于需要在Excel中嵌入图像的应用场景。

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

package com.appdev.test;

import java.awt.image.BufferedImage;
import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

import javax.imageio.ImageIO;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFPicture;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ImageToExcel {

	public static void main(String args[]) {
		String fileUrl = "D:/123.xls"; 
		try {
			 //创建输入流，读取Excel
			File file = new File(fileUrl);
			BufferedInputStream in = new BufferedInputStream(new FileInputStream(file));
			POIFSFileSystem fs = new POIFSFileSystem(in);
			//获取excel的sheet
			HSSFWorkbook wb = new HSSFWorkbook(fs);
			HSSFSheet sheet = wb.getSheetAt(0);
			//把图片流读取到字节流
			ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
			BufferedImage bufferImg = ImageIO.read(new File("D:/image002.gif"));
			ImageIO.write(bufferImg, "jpg", byteArrayOut);
			//HSSFClientAnchor控制图片的大小和位置
			HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255,
					(short) 2, 5, (short) 4, 6);
			anchor.setAnchorType(2);
			//HSSFPatriarch对流进行操作
			HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
			HSSFPicture pict = patriarch.createPicture(anchor, wb.addPicture(byteArrayOut
					.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
			//图片自适应
			pict.resize();
			FileOutputStream fileOut = null;
			fileOut = new FileOutputStream(fileUrl);
			wb.write(fileOut);
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}