Inserts a number of rows in the worksheet above the specified row.

 public void InsertRows(int rowNumber, int rowCount, RowInsertBehavior rowCellsCopyBehavior)
Public Sub InsertRows(ByVal rowNumber As Integer, ByVal rowCount As Integer, ByVal rowCellsCopyBehavior As RowInsertBehavior)

The 0-based number of the row to insert.

The number of rows to insert.

The Style.RowInsertBehavior that defines the source style for each cell in the new row. Each cell in the new row will be given the style of its neighbor identified in this parameter.

ws.InsertRows(3, 100, Style.InsertBehavior.CopyAreaFromBelow);
ws.InsertRows(3, 100, Style.InsertBehavior.CopyAreaFromBelow)