poi 获取excel中图片

最新推荐文章于 2026-06-04 13:47:43 发布

转载最新推荐文章于 2026-06-04 13:47:43 发布 · 4.1k 阅读

JAVA 同时被 2 个专栏收录

28 篇文章

订阅专栏

工具包应用

14 篇文章

订阅专栏

本文介绍了一种使用Java程序从Excel文件中读取图片数据，并将其保存为独立文件的方法。通过Apache POI库操作Excel文件，遍历工作表中的形状以找到图片，并将这些图片按其所在单元格位置保存。

转载自：http://fansfirst2008.iteye.com/blog/1138189

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.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.PictureData;
import org.apache.poi.ss.usermodel.WorkbookFactory;

public class ReadPicturesFromExcel {

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

        InputStream inp = new FileInputStream(
                "D:\\Users\\Fancy1_Fan\\桌面\\work\\test.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("jpeg")) {
            FileOutputStream out = new FileOutputStream(
                    "D:\\Users\\Fancy1_Fan\\桌面\\work\\pict" + i + ".jpg");
            out.write(data);
            out.close();
        }
        if (ext.equals("png")) {
            FileOutputStream out = new FileOutputStream(
                    "D:\\Users\\Fancy1_Fan\\桌面\\work\\pict" + i + ".png");
            out.write(data);
            out.close();
        }
    }

}

//获取sheet里所有图片信息 Map<row, picdata>
    private Map<Integer, HSSFPictureData> getPicMap(HSSFWorkbook workbook) {
        Map<Integer, HSSFPictureData> picMap = new HashMap<Integer, HSSFPictureData>();

        List<HSSFPictureData> pictures = workbook.getAllPictures();
        HSSFSheet sheet = (HSSFSheet) workbook.getSheetAt(0);

        for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
            HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();
            if (shape instanceof HSSFPicture) {
                HSSFPicture pic = (HSSFPicture) shape;
                HSSFPictureData picData = pictures.get(pic.getPictureIndex()-1);

                picMap.put(anchor.getRow1(), picData);
            } else {
                picMap.put(anchor.getRow1(), null);  //非图片数据则插入null
            }
        }

        return picMap;
    }