java 导入excel中的图片保存到本地

你可以使用 Apache POI 库来读取 Excel 文件并获取图片，然后使用 Java 的文件操作 API 将图片保存到本地。

以下是一个示例代码，可以帮助你实现这个功能：

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelImageExtractor {
    public static void extractImagesFromExcel(String filePath, String savePath) {
        try {
            Workbook workbook = new XSSFWorkbook(new File(filePath));
            int numberOfSheets = workbook.getNumberOfSheets();
            
            for (int i = 0; i < numberOfSheets; i++) {
                Drawing<?> drawing = workbook.getSheetAt(i).getDrawingPatriarch();
                if (drawing != null) {
                    drawing.forEach(shape -> {
                        if (shape.getImageData() != null) {
                            try {
                                InputStream imageStream = shape.getImageData().getData();
                                String imageExtension = shape.getPictureData().suggestFileExtension();
                                File outputFile = new File(savePath + File.separator + "image" + i + "." + imageExtension);
                                FileOutputStream outputStream = new FileOutputStream(outputFile);
                                byte[] buffer = new byte[1024];
                                int bytesRead;
                                while ((bytesRead = imageStream.read(buffer)) != -1) {
                                    outputStream.write(buffer, 0, bytesRead);
                                }
                                outputStream.close();
                                imageStream.close();
                            } catch (IOException e) {
                                e.printStackTrace();
                            }
                        }
                    });
                }
            }
            workbook.close();
        } catch (IOException | InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}

你可以调用 `extractImagesFromExcel` 方法，将 Excel 文件的路径和保存图片的路径作为参数传入。代码会自动读取 Excel 中的图片，并将它们保存到本地。