使用Apache POI从所有excel工作表读取图像

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.util.IOUtils;

import java.io.FileInputStream;
import java.io.IOException;

public class ExcelImageReader {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx"; // Excel文件路径

        try (FileInputStream fis = new FileInputStream(filePath)) {
            Workbook workbook;
            if (filePath.endsWith(".xlsx")) {
                workbook = new XSSFWorkbook(fis); // 处理xlsx格式的Excel文件
            } else if (filePath.endsWith(".xls")) {
                workbook = new HSSFWorkbook(fis); // 处理xls格式的Excel文件
            } else {
                throw new IllegalArgumentException("Unsupported Excel format");
            }

            for (int sheetIndex = 0; sheetIndex < workbook.getNumberOfSheets(); sheetIndex++) {
                Sheet sheet = workbook.getSheetAt(sheetIndex);

                for (Drawing<?> drawing : sheet.getDrawingPatriarch().getChildren()) {
                    if (drawing instanceof Picture) {
                        Picture picture = (Picture) drawing;
                        byte[] imageData = picture.getData().getData();
                        // 处理图像数据
                        // ...
                    }
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}