private void mergeFileSheet(File originalFile, List fileUrls) throws Exception { try (FileInputStream fis = new FileInputStream(originalFile); Workbook originalWorkbook = new XSSFWorkbook(fis)) { for (Strin...-Go服务器开发

要支持单元格图片复制，你可以使用Drawing和Picture类来处理。下面是修改后的代码示例：

”`java 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:
                // 默认处理
        }

        // 复制单元格中的图片（如果存在）
        Drawing<?> drawingPatriarch = source.getSheet().createDrawingPatriarch();

        for (Object obj : drawingPatriarch) {
            if (obj instanceof Picture) {
                Picture picture = (Picture) obj;
                if (picture.getRow() == source.getRowIndex() && picture.getColumn() == sourceCell.getColumnIndex()) {
                    ClientAnchor anchor = picture.getClientAnchor();

                    // 计算图片在新单元格中的位置
                    int targetRowNum = target.getRowNum();
                    int targetColNum = targetCell.getColumnIndex();

                    int dx1 = anchor.getDx1();
                    int dy1 = anchor.getDy1();
                    int dx2 = anchor.getDx2();
                    int dy2 = anchor.getDy2();

                    ClientAnchor newAnchor = workbook.getCreationHelper().createClientAnchor();

                    newAnchor.setDx1(dx1);
                    newAnchor.setDy1(dy1);
                    newAnchor.setDx2(dx2);
                    newAnchor.setDy2(dy2);

                    newAnchor.setRow1(targetRowNum);
                    newAnchor.setRow2(targetRowNum);
                    newAnchor.setCol1(targetColNum);
                    newAnchor.setCol2(targetColNum);

                    PictureData pictureData = picture.getPictureData();

   <br/><br/><br/><font size=1 color=#CCCCCC>内容由零声教学AI助手提供，问题来源于学员提问</font>