RowCollection.Insert(Int32, Int32, RowFormatMode) Method

Inserts multiple rows into the worksheet and specifies insert options.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

void Insert(
    int index,
    int count,
    RowFormatMode formatMode
)

VB.NET

Sub Insert(
    index As Integer,
    count As Integer,
    formatMode As RowFormatMode
)

Parameters

Name	Type	Description
index	Int32	An integer specifying the zero-based index of the position where new rows shall be inserted. If it is negative or exceeds the last available index (1048575), an exception is raised.
count	Int32	An integer specifying the number of rows to be inserted.
formatMode	RowFormatMode	One of the RowFormatMode enumeration members specifying how to format inserted rows.

Remarks

The number of rows in a worksheet is unchanged - 1,048,576. When you add new rows, other rows in the worksheet are shifted down and the equivalent number of rows at the end are automatically removed from the worksheet.

The formatMode parameter allows you to specify how to format inserted rows:

RowFormatMode	Description
RowFormatMode.FormatAsPrevious	Inserted rows have the same formatting as the row above:
RowFormatMode.FormatAsNext	Inserted rows have the same formatting as the row below:
RowFormatMode.None	Inserted rows have no formatting applied: