RangeExtensions.Insert(CellRange) Method

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

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp

public static void Insert(
    this CellRange range
)

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

Name	Type	Description
range	CellRange

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

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).