RangeExtensions.Insert(CellRange) Method

Inserts the cell range in the worksheet, shifting other cells in the same column down.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public static void Insert(
    this CellRange range
)

VB.NET

<ExtensionAttribute>
Public Shared Sub Insert(
    range As CellRange
)

Parameters

Name	Type	Description
range	CellRange	A CellRange object specifying a cell range where new cells should be inserted.

Remarks

The Insert method is an extension method of the CellRange object that is called by using the instance method syntax.

To delete cells, use the RangeExtensions.Delete method.

Another way to insert and delete cells in the worksheet is to use the worksheet’s Worksheet.InsertCells and Worksheet.DeleteCells methods (see the How to: Insert a Cell or Cell Range and How to: Delete a Cell or Range of Cells examples).