要支持复制图片类型，可以进行以下优化：

1. 使用POI提供的Drawing和CreationHelper来处理图像。

2. 遍历源行的每个单元格时，判断单元格是否为图片类型。如果是图片类型，则获取图片，并在目标行创建一个相应的单元格，将图片插入到目标单元格中。

下面是修改后的代码片段：

private void copyRow(Row source, Row target, Workbook workbook) {
    for (int i = source.getFirstCellNum(); i <= source.getLastCellNum(); i++) {
        Cell sourceCell = source.getCell(i);
        if (sourceCell != null) {
            Cell targetCell = target.createCell(i, sourceCell.getCellType());
            
            // 复制单元格样式
            CellStyle sourceCellStyle = sourceCell.getCellStyle();
            CellStyle targetCellStyle = workbook.createCellStyle();
            targetCellStyle.cloneStyleFrom(sourceCellStyle);
            targetCell.setCellStyle(targetCellStyle);
            
            // 根据单元格类型复制值
            switch (sourceCell.getCellTypeEnum()) {
                case STRING:
                    targetCell.setCellValue(sourceCell.getStringCellValue());
                    break;
                case NUMERIC:
                    targetCell.setCellValue(sourceCell.getNumericCellValue());
                    break;
                case BOOLEAN:
                    targetCell.setCellValue(sourceCell.getBooleanCellValue());
                    break;
                case FORMULA:
                    // 如果是公式，复制公式本身
                    targetCell.setCellFormula(sourceCell.getCellFormula());
                    break;
                case BLANK:
                    // 空白单元格处理
                    break;
                default:
                    // 默认处理
            }
            
            // 判断是否为图片类型
            if (sourceCell.getCellTypeEnum() == CellType.PICTURE) {
                if (workbook instanceof XSSFWorkbook && sourceCell instanceof XSSFPicture) {
                    // 处理XSSF格式的图片
                    XSSFPicture sourcePicture = (XSSFPicture) sourceCell;
                    XSSFDrawing drawing = ((XSSFSheet) source.getSheet()).createDrawingPatriarch();
                    byte[] pictureData = sourcePicture.getPictureData().getData();
                    int pictureIndex = workbook.addPicture(pictureData, Workbook.PICTURE_TYPE_PNG);
                    
                    XSSFClientAnchor anchor = createAnchor(sourcePicture.getPreferredSize());
                    anchor.setCol1(targetCell.getColumnIndex());
                    anchor.setCol2(targetCell.getColumnIndex() + 1);
                    anchor.setRow1(target.getRowNum());
                    anchor.setRow2(target.getRowNum() + 1);
                    
                    drawing.createPicture(anchor, pictureIndex);
                } else if (workbook instanceof HSSFWorkbook && sourceCell instanceof HSSFPicture) {
                    // 处理HSSF格式的图片
                    HSSFPicture sourcePicture = (HSSFPicture) sourceCell;
                    HSSFPatriarch drawing = ((HSSFSheet) source.getSheet()).createDrawingPatriarch();
                    
                    ClientAnchor anchor = createAnchor(sourcePicture.getClientAnchor());
                    
                    int pictureIndex = workbook.addPicture(sourcePicture.getPictureData().getData(), Workbook.PICTURE_TYPE_PNG);
                    
                    drawing.createPicture(anchor, pictureIndex);
                }
            }
        }
    }
}

private XSSFClientAnchor createAnchor(PreferredSize preferredSize) {
    XSSFClientAnchor anchor = new XSSFClientAnchor();
    anchor.setDx1(preferredSize.getDx1());
    anchor.setDy1(preferredSize.getDy1());
    anchor.setDx2(preferredSize.getDx2());
    anchor.setDy2(preferredSize.getDy2());
    return anchor;
}

private ClientAnchor createAnchor(org.apache.poi.hssf.usermodel.HSSFClientAnchor oldAnchor) {
    ClientAnchor anchor = new HSSFClientAnchor();
    anchor.setCol1(oldAnchor.getCol1());
    anchor.setRow1(oldAnchor.getRow1());
    anchor.setDx1(oldAnchor.getDx1());
    anchor.setDy1(oldAnchor.getDy1());
    anchor.setCol2(oldAnchor.getCol2());
    anchor.setRow2(oldAnchor.getRow2());
    anchor.setDx2(oldAnchor.getDx2());
    anchor.setDy2(oldAnchor.getDy2());
    return anchor;
}

这样修改后的代码可以支持复制图片类型，并将源单元格中的图片复制到目标单元格中。请确保在使用前导入所需的POI库和相关类。


内容由零声教学AI助手提供，问题来源于学员提问