Java 向表格中导入图片

最新推荐文章于 2024-07-20 18:01:34 发布

llwan

最新推荐文章于 2024-07-20 18:01:34 发布

阅读量2.3k

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/llwan/article/details/8349793

版权

Java 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

package test;

import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
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.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class TestPOI {

   public static void main(String[] args) {
       FileOutputStream fileOut = null;
       BufferedImage bufferImg = null;
       try {

           // 先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
           ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
           bufferImg = ImageIO
                   .read(new File(
                           "D:\\1346121647928.jpg"));
           ImageIO.write(bufferImg, "jpg", byteArrayOut);

           // 创建一个工作薄
           HSSFWorkbook wb = new HSSFWorkbook();
           HSSFSheet sheet1 = wb.createSheet("Sheet1");

           // 要导入的图片显示大小198*198像素
           HSSFRow row = sheet1.createRow(0);
           sheet1.setColumnWidth(0, (int) (35.7 * 198));
           row.setHeight((short) (15.625 * 198));
           HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
           HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255,
                   (short) 0, 0, (short) 0, 0);// 1023*255表示占满单元格
           // 插入图片
           patriarch.createPicture(anchor, wb.addPicture(byteArrayOut
                   .toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));

           fileOut = new FileOutputStream("d:/test.xls");
           // 写入excel文件
           wb.write(fileOut);
           fileOut.close();

       } catch (IOException io) {
           io.printStackTrace();
           System.out.println("io erorr : " + io.getMessage());
       } finally {
           if (fileOut != null) {

               try {
                   fileOut.close();
               } catch (IOException e) {
                   // TODO Auto-generated catch block
                   e.printStackTrace();
               }
           }
       }
   }
}