Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class / CutAndPasteTo Method
Example


In This Topic
    CutAndPasteTo Method
    In This Topic
    Cuts a CellRange & pastes it to another location. 
    Overload List
    OverloadDescription
    Removes the CellRange from its current location and pastes it to a new location, using the Address of a Cell to determine where the data will be pasted.    
    Removes the CellRange from its current location and pastes it to a new location, using a RowID & a ColumnID to determine where the data will be pasted.   
    Example
    // Cuts a CellRange & pastes it using the Address of a Cell to identify the target location, which will be located in another Worksheet, identified by the otherSheet object. All content, as well as its formatting, will be pasted to this new location.
    Worksheet otherSheet = workbook.Worksheet[ 0 ]; 
     
    worksheet.Cells[ "D4", "H12" ].CutAndPasteTo( "C3", PasteOptions.All, otherSheet );
    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also