java解析Excel中图片

package org.springblade.common.utils;

import org.apache.poi.POIXMLDocumentPart;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.PictureData;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.*;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.atomic.AtomicInteger;


public class ExcelImageConverter {

	public static void main(String[] args) throws IOException {
		String filePath = "C:\Users\Administrator\Downloads\Image.xlsx";
		Map image = getImage(filePath);
		System.out.println(image);
	}

	
	public static Map getImage(String filePath) throws IOException {
		if (!filePath.endsWith(".xls") && !filePath.endsWith(".xlsx")) {
			throw new RuntimeException("后缀必须是.xls或.xlsx");
		}
		Workbook wookbook;
		Sheet sheet;
		try(FileInputStream fis = new FileInputStream(filePath)) {
			if (filePath.endsWith(".xls")) {
				// 2003版本的excel，用.xls结尾
				wookbook = new HSSFWorkbook(fis); // 得到工作簿
				sheet = wookbook.getSheetAt(0);
				return getImageXLS((HSSFSheet) sheet);
			} else {
				// 2007版本的excel，用.xlsx结尾
				wookbook = new XSSFWorkbook(fis);//得到工作簿
				sheet = wookbook.getSheetAt(0);
				return getImageXLSX((XSSFSheet) sheet);
			}
		}
	}

	
	public static Map getImageXLS(HSSFSheet sheet) {
		AtomicInteger index = new AtomicInteger();
		Map map = new HashMap<>();
		List shapes = sheet.getDrawingPatriarch().getChildren();
		shapes.forEach(v -> {
			if (v instanceof HSSFPicture) {
				HSSFPicture picture = (HSSFPicture) v;
				HSSFClientAnchor cAnchor = (HSSFClientAnchor) picture.getAnchor();
				PictureData data = picture.getPictureData();
				// 行号-列号-图片序号
				String key = cAnchor.getRow1() + "-" + cAnchor.getCol1() + "-" + index.getAndIncrement();
				map.put(key, data);
			}
		});
		return map;
	}

	
	public static Map getImageXLSX(XSSFSheet sheet) {
		AtomicInteger index = new AtomicInteger();
		Map map = new HashMap<>();
		List documentParts = sheet.getRelations();
		documentParts.forEach(v -> {
			if (v instanceof XSSFDrawing) {
				XSSFDrawing drawing = (XSSFDrawing) v;
				List shapes = drawing.getShapes();
				shapes.forEach(s -> {
					XSSFPicture picture = (XSSFPicture) s;
					XSSFClientAnchor anchor = picture.getPreferredSize();
					CTMarker marker = anchor.getFrom();
					String key = marker.getRow() + "-" + marker.getCol() + "-" + index.getAndIncrement();
					map.put(key, picture.getPictureData());
				});
			}
		});
		return map;
	}

}