使用apache poi在合并单元格中水平居中显示图像

Workbook workbook = new XSSFWorkbook();

Sheet sheet = workbook.createSheet("Sheet1");

CellRangeAddress mergedRegion = new CellRangeAddress(0, 2, 0, 2);
sheet.addMergedRegion(mergedRegion);

InputStream inputStream = new FileInputStream("path/to/image.jpg");
byte[] imageBytes = IOUtils.toByteArray(inputStream);
int pictureIdx = workbook.addPicture(imageBytes, Workbook.PICTURE_TYPE_JPEG);

CreationHelper helper = workbook.getCreationHelper();
Drawing<?> drawing = sheet.createDrawingPatriarch();

ClientAnchor anchor = helper.createClientAnchor();
anchor.setCol1(mergedRegion.getFirstColumn());
anchor.setRow1(mergedRegion.getFirstRow());
anchor.setCol2(mergedRegion.getLastColumn());
anchor.setRow2(mergedRegion.getLastRow());

Picture picture = drawing.createPicture(anchor, pictureIdx);
picture.resize();

picture.setHorizontalAlignment(HorizontalAlignment.CENTER);

FileOutputStream fileOut = new FileOutputStream("path/to/output.xlsx");
workbook.write(fileOut);
fileOut.close();