Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Cell Class / CopyAndPasteTo Method
Where the data will be pasted; this can be either an Address (ie. "D14") or a RowID followed by a ColumnID (ie. 4, 5).
The PasteOptions; in other words, this determines what will be pasted into the new Cell.
The CopyOptions; in other words, this determines if the Cell will be copied or cut. 
Example


In This Topic
    CopyAndPasteTo Method (Cell)
    In This Topic
    Copies or cuts a Cell & pastes it into another Cell.
    Syntax
    'Declaration
 

    Public Sub CopyAndPasteTo( _
   ByVal to As Cell, _
   Optional ByVal pasteOptions As PasteOptions, _
   Optional ByVal copyOptions As CopyOptions _
) 
    'Usage
 

    Dim instance As Cell
Dim to As Cell
Dim pasteOptions As PasteOptions
Dim copyOptions As CopyOptions
 
instance.CopyAndPasteTo(to, pasteOptions, copyOptions)
    public void CopyAndPasteTo( 
   Cell to,
   PasteOptions pasteOptions,
   CopyOptions copyOptions
)

    Parameters

    to
    Where the data will be pasted; this can be either an Address (ie. "D14") or a RowID followed by a ColumnID (ie. 4, 5).
    pasteOptions
    The PasteOptions; in other words, this determines what will be pasted into the new Cell.
    copyOptions
    The CopyOptions; in other words, this determines if the Cell will be copied or cut. 
    Example
    // Copies Cell A1 to Cell A12.
worksheet.Cells[ "A1" ].CopyAndPasteTo( worksheet.Cells[ "A12" ] );
    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

    Cell Class
    Cell Members

    Send Feedback