Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Commands Namespace / ClipboardInsertCommand Class / InsertCells Method / InsertCells(Worksheet,Int32,Int32,Worksheet,ManipulationOptions,Boolean,InsertShiftDirection,Boolean) Method
The source worksheet.
An integer value indicates the top row index of source cell range.
An integer value indicates the left column index of source cell range.
The target worksheet.
A GrapeCity.Spreadsheet.ManipulationOptions value indicates the processing data options.
A boolean value indicates whether the source cell range will be clear.
An GrapeCity.Spreadsheet.InsertShiftDirection value indicates how cells are shifted.


In This Topic
    InsertCells(Worksheet,Int32,Int32,Worksheet,ManipulationOptions,Boolean,InsertShiftDirection,Boolean) Method
    In This Topic
    Initializes a new instance of the ClipboardInsertCommand class.
    Syntax
    'Declaration
     
    
    Public Overloads Shared Function InsertCells( _
       ByVal sourceWorksheet As Worksheet, _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal targetWorksheet As Worksheet, _
       ByVal manipulationOptions As ManipulationOptions, _
       ByVal clearSource As Boolean, _
       ByVal insertOptions As InsertShiftDirection, _
       ByVal copyMode As Boolean _
    ) As Command
    'Usage
     
    
    Dim sourceWorksheet As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim targetWorksheet As Worksheet
    Dim manipulationOptions As ManipulationOptions
    Dim clearSource As Boolean
    Dim insertOptions As InsertShiftDirection
    Dim copyMode As Boolean
    Dim value As Command
     
    value = ClipboardInsertCommand.InsertCells(sourceWorksheet, row, column, targetWorksheet, manipulationOptions, clearSource, insertOptions, copyMode)

    Parameters

    sourceWorksheet
    The source worksheet.
    row
    An integer value indicates the top row index of source cell range.
    column
    An integer value indicates the left column index of source cell range.
    targetWorksheet
    The target worksheet.
    manipulationOptions
    A GrapeCity.Spreadsheet.ManipulationOptions value indicates the processing data options.
    clearSource
    A boolean value indicates whether the source cell range will be clear.
    insertOptions
    An GrapeCity.Spreadsheet.InsertShiftDirection value indicates how cells are shifted.
    copyMode
    See Also