Xceed Workbooks for .NET v2.0 Documentation
CopyAndPasteTo Method (Cell)
Example 


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. 
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" ] );
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

Reference

Cell Class
Cell Members