要支持复制图片类型，您可以使用Apache POI的HSSFPatriarch和XSSFDrawing类来处理图像。以下是优化后的代码示例：

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:
                    // Do nothing or handle blank cells as needed
                    break;
                default:
                    // 默认处理
            }
            
            // 处理图像类型的单元格
            if (source.getCellType() == CellType.BLANK && source.getSheet().getDrawingPatriarch() != null) {
                Drawing<?> drawing = null;
                
                if (workbook instanceof XSSFWorkbook) {
                    XSSFSheet sourceSheet = (XSSFSheet) source.getSheet();
                    drawing = sourceSheet.createDrawingPatriarch();
                } else if (workbook instanceof HSSFWorkbook) {
                    HSSFSheet sourceSheet = (HSSFSheet) source.getSheet();
                    drawing = sourceSheet.createDrawingPatriarch();
                }
                
                if (drawing != null) {
                    for (Object obj : drawing.getShapes()) {
                        if (obj instanceof Picture) {
                            Picture picture = (Picture) obj;
                            if (picture.getRow() == source.getRowIndex() && picture.getColumn() == i) {
                                int pictureIndex = workbook.addPicture(picture.getData(), Workbook.PICTURE_TYPE_PNG);
                                CreationHelper creationHelper = workbook.getCreationHelper();
                                ClientAnchor anchor = creationHelper.createClientAnchor();
                                anchor.setCol1(targetCell.getColumnIndex());
                                anchor.setRow1(targetCell.getRowIndex());
                                
                                Drawing<?> targetDrawing;
                                
                                if (workbook instanceof XSSFWorkbook) {
                                    XSSFSheet targetSheet = (XSSFSheet) targetCell.getSheet();
                                    targetDrawing = targetSheet.createDrawingPatriarch();
                                } else if (workbook instanceof HSSFWorkbook) {
                                    HSSFSheet targetSheet = (HSSFSheet) targetCell.getSheet();
                                    targetDrawing = targetSheet.createDrawingPatriarch();
                                }
                                
                                if (targetDrawing != null) {
                                    Picture newPicture = targetDrawing.createPicture(anchor, pictureIndex);
                                    newPicture.resize();  // 调整图片大小
                                    
                                    break;  // 如果有多个图像，仅复制第一个匹配的图像
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

这样，您可以在复制行时处理图片类型的单元格。注意要根据您实际的工作簿类型（XSSFWorkbook或HSSFWorkbook）来使用适当的类和方法。


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