要支持单元格图片复制，你需要修改copyRow方法来处理图片。以下是优化后的代码示例：

private void copyRow(Row source, Row target, Workbook workbook) {
    // 遍历源行的每个单元格
    for (int i = source.getFirstCellNum(); i <= source.getLastCellNum(); i++) {
        Cell sourceCell = source.getCell(i);
        // 如果源单元格为null，则不创建新单元格
        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.getCellType() == CellType.BLANK && source instanceof XSSFSheet) {
                XSSFSheet sheet = (XSSFSheet) source.getSheet();
                
                Drawing<?> drawingPatriarch = sheet.createDrawingPatriarch();
                for (XSSFShape shape : drawingPatriarch.getShapes()) {
                    if (shape instanceof XSSFPicture) {
                        XSSFPicture picture = (XSSFPicture) shape;
                        if (picture.getAnchor().equals(sourceCell.getColumnIndex(), sourceCell.getRowIndex())) {
                            ClientAnchor anchor = picture.getClientAnchor();
                            int rowOffset = target.getRowNum() - source.getRowNum();
                            
                            // 计算新的图片位置
                            int newCol1 = anchor.getCol1();
                            int newRow1 = anchor.getRow1() + rowOffset;
                            int newCol2 = anchor.getCol2();
                            int newRow2 = anchor.getRow2() + rowOffset;
                            
                            // 创建新的图片
                            XSSFDrawing targetDrawingPatriarch = (XSSFDrawing) ((XSSFSheet) target.getSheet()).createDrawingPatriarch();
                            XSSFClientAnchor newAnchor = workbook.getCreationHelper().createClientAnchor();
                            newAnchor.setDx1(anchor.getDx1());
                            newAnchor.setDy1(anchor.getDy1());
                            newAnchor.setDx2(anchor.getDx2());
                            newAnchor.setDy2(anchor.getDy2());
                            
                             // 设置新的图片位置
                             newAnchor.setRow1(newRow1);
                             newAnchor.setRow2(newRow2);
                             newAnchor.setCol1(newCol1);
                             newAnchor.setCol2(newCol2);
                             
                             // 复制图片数据到新单元格
                             byte[] pictureData = picture.getPictureData().getData();
                             int pictureIndex = workbook.addPicture(pictureData, Workbook.PICTURE_TYPE_PNG);
                             XSSFPictureData xssfPictureData = (XSSFPictureData) workbook.getAllPictures().get(pictureIndex);
                             
                             targetDrawingPatriarch.createPicture(newAnchor, workbook.addPicture(pictureData, xssfPictureData.getPictureType()));
                        }
                    }
                }
            }
        }
    }
}

这样，复制单元格时会同时复制单元格的值和图片（如果有）。请注意，此代码仅适用于XSSF格式的Excel文件。如果你使用的是HSSF格式，请相应地进行调整。


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