import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

public class MergeImagesInCell {

    public static void main(String[] args) throws IOException {
        String fileName = "images.xlsx";

        // 准备数据
        String[] imagePaths = {"image1.png", "image2.png", "image3.png"}; // 假设有三张图片

        // 创建 Excel 工作簿
        try (Workbook workbook = new XSSFWorkbook()) {
            Sheet sheet = workbook.createSheet("Images");

            int rownum = 0;
            for (String imagePath : imagePaths) {
                BufferedImage bufferedImage = ImageIO.read(new File(imagePath));

                // 将图片转换为字节数组
                ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
                ImageIO.write(bufferedImage, "png", byteArrayOutputStream);
                byte[] bytes = byteArrayOutputStream.toByteArray();
                byteArrayOutputStream.close();

                // 将图片插入到单元格
                CreationHelper creationHelper = workbook.getCreationHelper();
                Drawing drawing = sheet.createDrawingPatriarch();
                ClientAnchor anchor = creationHelper.createClientAnchor();
                anchor.setCol1(rownum); // 设置单元格起始列
                anchor.setRow1(0); // 设置单元格起始行
                anchor.setCol2(rownum + 1); // 设置单元格结束列
                anchor.setRow2(1); // 设置单元格结束行
                Picture picture = drawing.createPicture(anchor, workbook.addPicture(bytes, Workbook.PICTURE_TYPE_PNG));
                picture.resize(); // 调整图片大小以适应单元格

                // 合并单元格
                sheet.addMergedRegion(new CellRangeAddress(0, 0, rownum, rownum + 1));

                rownum += 2; // 每个图片占用两列
            }

            // 保存 Excel 文件
            try (FileOutputStream fileOut = new FileOutputStream(fileName)) {
                workbook.write(fileOut);
            }
        }
    }
}