复制excel行到指定行

最新推荐文章于 2024-01-09 20:43:36 发布

腿毛ger

最新推荐文章于 2024-01-09 20:43:36 发布

阅读量619

点赞数

分类专栏： Teamcenter rac 文章标签： java 开发语言后端

本文链接：https://blog.csdn.net/weixin_44942769/article/details/125991964

版权

Teamcenter rac 专栏收录该内容

85 篇文章 14 订阅

订阅专栏

  /**
     * 行复制功能
     * 
     * @param fromRow
     * @param toRow
     */
    public static void _copyRow(Workbook wb,Sheet sheet, Row fromRow, Row toRow, boolean copyValueFlag) {
        toRow.setHeight(fromRow.getHeight());
        for(int i = 0; i < sheet.getNumMergedRegions(); i++) {
               CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i);
               if(cellRangeAddress.getFirstRow() == fromRow.getRowNum()) {
                   CellRangeAddress newCellRangeAddress = new CellRangeAddress(toRow.getRowNum(), (toRow.getRowNum() +
                           (cellRangeAddress.getLastRow() - cellRangeAddress.getFirstRow())), cellRangeAddress
                           .getFirstColumn(), cellRangeAddress.getLastColumn());
                   sheet.addMergedRegion(newCellRangeAddress);
               }
           }
        
        for (Iterator cellIt = fromRow.cellIterator(); cellIt.hasNext();) {
            Cell tmpCell = (Cell) cellIt.next();
            Cell newCell = toRow.createCell(tmpCell.getColumnIndex());
            _copyCell(wb, tmpCell, newCell, copyValueFlag);
            
        }
    }
    
    public static void _copyCell(Workbook wb,Cell srcCell, Cell distCell,  
            boolean copyValueFlag) {  
        CellStyle newstyle=wb.createCellStyle();  
        newstyle.cloneStyleFrom(srcCell.getCellStyle()); 
        //样式   
        distCell.setCellStyle(newstyle);  
        //评论   
        if (srcCell.getCellComment() != null) {  
            distCell.setCellComment(srcCell.getCellComment());  
        }  
        // 不同数据类型处理   
        int srcCellType = srcCell.getCellType();  
        distCell.setCellType(srcCellType);  
        if (copyValueFlag) {  
            if (srcCellType == Cell.CELL_TYPE_NUMERIC) {  
                if (HSSFDateUtil.isCellDateFormatted(srcCell)) {  
                    distCell.setCellValue(srcCell.getDateCellValue());  
                } else {  
                    distCell.setCellValue(srcCell.getNumericCellValue());  
                }  
            } else if (srcCellType == Cell.CELL_TYPE_STRING) {  
                distCell.setCellValue(srcCell.getRichStringCellValue());  
            } else if (srcCellType == Cell.CELL_TYPE_BLANK) {  
                // nothing21   
            } else if (srcCellType == Cell.CELL_TYPE_BOOLEAN) {  
                distCell.setCellValue(srcCell.getBooleanCellValue());  
            } else if (srcCellType == Cell.CELL_TYPE_ERROR) {  
                distCell.setCellErrorValue(srcCell.getErrorCellValue());  
            } else if (srcCellType == Cell.CELL_TYPE_FORMULA) {  
                distCell.setCellFormula(srcCell.getCellFormula());  
            } else { // nothing29  
            }  
        }  
    }