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


In This Topic
    CopyAndPasteTo Method (CellRange)
    In This Topic
    Copies a CellRange & pastes it to another location.
    Overload List
    OverloadDescription
    Copies 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.    
    Copies 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
    // Copies a CellRange & pastes it using a RowID & A ColumnID to identify the target location, which will be located in another Worksheet, identified by the otherSheet object. All content will be pasted to the new location, but the content from the rows will be pasted into columns & the content of the columns will be pasted into rows.
    Worksheet otherSheet = workbook.Worksheet[ 0 ]; 
     
    worksheet.Cells[ "D4", "F12" ].CopyAndPasteTo( 15, 5 , PasteOptions.All | PasteOptions.Transpose, 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