InsertRows Method

Inserts rows at the specified index.

Syntax

[VB.NET]
Public Sub InsertRows(ByVal RowIndex As Integer, ByVal RowCount As Integer)

[C#]
public void InsertRows(int rowIndex, int rowCount);

Remarks

This method inserts RowCount rows at the specified RowIndex. The RowIndex parameter is 0-based. Valid values for RowIndex are from 0 to RowCount. When inserting rows, the existing rows will be shifted to down. Cell formatting will be preserved. For instance to insert 3 rows at row 3:

Exceldoc1.InsertRow(2,3);