Move(Int32,Int32,Int32,Int32,Int32,Int32,ManipulationOptions,Worksheet) Method
In This Topic
Moves the data from a range of cells to the specified location.
Syntax
'Declaration
Public Overloads Function Move( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal toColumn As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As ManipulationOptions, _
Optional ByVal As Worksheet _
) As ActionResult(Of Object)
'Usage
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim options As ManipulationOptions
Dim targetWorksheet As Worksheet
Dim value As ActionResult(Of Object)
value = instance.Move(row, column, toRow, toColumn, rowCount, columnCount, options, targetWorksheet)
Parameters
- row
- Row index of starting position of range to move
- column
- Column index of starting position of range to move
- toRow
- Row index of starting position of destination
- toColumn
- Column index of starting position of destination
- rowCount
- Number of rows in range
- columnCount
- Number of columns in range
- options
- The options indicates which data type will be performed.
- targetWorksheet
- The target worksheet where data will be copied to.
null
means the data is copied to the same worksheet.
Return Value
true
if the cell range is moved successful, false
otherwise.
See Also