POI导出Exel表中图片到文件夹下

最新推荐文章于 2025-01-08 11:25:14 发布

秋夜雨微凉

最新推荐文章于 2025-01-08 11:25:14 发布

阅读量633

点赞数

CC 4.0 BY-SA版权

分类专栏： java操作Excel

本文链接：https://blog.youkuaiyun.com/u013183865/article/details/32172299

java操作Excel 专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了使用POI库从Excel文件中批量导出图片至指定文件夹的过程，包括读取Excel文件、获取图片数据、保存图片至本地文件等步骤。

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

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.util.List;



import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFPicture;

import org.apache.poi.hssf.usermodel.HSSFPictureData;

import org.apache.poi.hssf.usermodel.HSSFShape;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.PictureData;

import org.apache.poi.ss.usermodel.WorkbookFactory;



/**

* POI导出Exel表中图片到文件夹下

* @author ambo.lch

*

*/

public class ReadPicturesFromExcel {



   public static void main(String[] args) throws Exception {



       InputStream inp = new FileInputStream("D:/aaa.xls");

       HSSFWorkbook workbook = (HSSFWorkbook) WorkbookFactory.create(inp);

       List<HSSFPictureData> pictures = workbook.getAllPictures();

       HSSFSheet sheet = (HSSFSheet) workbook.getSheetAt(0);

       int i = 0;

       for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {

           HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();



           if (shape instanceof HSSFPicture) {

               HSSFPicture pic = (HSSFPicture) shape;

               int row = anchor.getRow1();

               System.out.println(i + "--->" + anchor.getRow1() + ":"+ anchor.getCol1());

               int pictureIndex = pic.getPictureIndex()-1;

               HSSFPictureData picData = pictures.get(pictureIndex);

               System.out.println(i + "--->" + pictureIndex);

               savePic(row, picData);

           }

           i++;

       }

   }



   private static void savePic(int i, PictureData pic) throws Exception {

       String ext = pic.suggestFileExtension();

       byte[] data = pic.getData();

       if (ext.equals("jepg")||ext.equals("jpg")) {

           FileOutputStream out = new FileOutputStream("D:\\1111\\pict" + i + ".jpg");

           out.write(data);

           out.close();

       }

       if (ext.equals("png")) {

           FileOutputStream out = new FileOutputStream("D:\\1111\\pict" + i + ".png");

           out.write(data);

           out.close();

       }

   }



}