poi 写图片到excel

最新推荐文章于 2020-08-20 17:36:00 发布

月冷无双

最新推荐文章于 2020-08-20 17:36:00 发布

阅读量1k

点赞数

分类专栏： Java 文章标签： poi 写图片到excel

本文链接：https://blog.youkuaiyun.com/u014452858/article/details/40635301

版权

Java 专栏收录该内容

18 篇文章

订阅专栏

这篇博客主要介绍了如何利用Apache POI库在Java中将图片插入到Excel文件的过程，从原始图片开始，经过程序处理，最终成功将图片写入Excel。

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

原图片:

进入程序:

package com.tom;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.Picture;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.util.IOUtils;

public class CreateSheetWithPNG {
	public static void main(String[] args) throws Exception{
		//create a new workbook
	    Workbook wb = new HSSFWorkbook(); 

	    //add picture data to this workbook.
	    InputStream is = new FileInputStream("F:/美女.png");
	    byte[] bytes = IOUtils.toByteArray(is);
	    int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
	    is.close();

	    CreationHelper helper = wb.getCreationHelper();

	    //create sheet
	    Sheet sheet = wb.createSheet();

	    // Create the drawing patriarch.  This is the top level container for all shapes. 
	    Drawing drawing = sheet.createDrawingPatriarch();

	    //add a picture shape
	    ClientAnchor anchor = helper.createClientAnchor();
	    //set top-left corner of the picture,
	    //subsequent call of Picture#resize() will operate relative to it
	    anchor.setCol1(3);
	    anchor.setRow1(2);
	    Picture pict = drawing.createPicture(anchor, pictureIdx);

	    //auto-size picture relative to its top-left corner
	    pict.resize();

	    //save workbook
	    String file = "F:/CreateSheetWithPNG.xls";
	    FileOutputStream fileOut = new FileOutputStream(file);
	    wb.write(fileOut);
	    fileOut.close();
	}
}

出来后: