excel导入图片 Java

在Java中导入Excel中的图片，需要使用Apache POI库。下面是一个简单的示例代码：

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

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.PictureData;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.util.IOUtils;

public class ExcelImageImporter {

    public static void main(String[] args) throws InvalidFormatException, IOException {
        File file = new File("example.xlsx");
        FileInputStream fis = new FileInputStream(file);
        Workbook workbook = WorkbookFactory.create(fis);

        Drawing drawing = workbook.getSheetAt(0).getDrawingPatriarch();
        if (drawing != null) {
            for (PictureData pictureData : drawing.getPictures()) {
                byte[] data = pictureData.getData();
                String fileName = pictureData.suggestFullFileName();
                String fileExtension = pictureData.suggestFileExtension();

                //保存图片文件
                File imageFile = new File(fileName + "." + fileExtension);
                IOUtils.write(data, imageFile);
            }
        }

        workbook.close();
        fis.close();
    }
}

在这个示例中，我们首先使用`WorkbookFactory`类创建一个`Workbook`对象，然后获取工作表中的绘图对象`Drawing`。接着遍历`Drawing`中的所有图片数据，并将其保存到磁盘上。