Xceed Logo
Shop
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
    CutAndPasteTo(String,PasteOptions,Worksheet)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.    
    CutAndPasteTo(Int32,Int32,PasteOptions,Worksheet)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 );
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    CellRange Class
    CellRange Members

    Send Feedback