Page History

{description}
{excerpt}Inserts a row in the worksheet above the specified row.{excerpt}
{signature:C#}
 public void InsertRow(int rowNumber, RowInsertBehavior rowCellsCopyBehavior, RowInsertBehavior rowCopyBehavior)
{signature}{signature:vb.net}
Public Sub InsertRow(ByVal rowNumber As Integer, ByVal rowCellsCopyBehavior As RowInsertBehavior, ByVal rowCopyBehavior As RowInsertBehavior)
{signature}
{parameters}
{param:rowNumber}The 0\-based number of the row to insert.{param}
{param:rowCellsCopyBehavior}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.{param}
{param:rowCopyBehavior}The Style.RowInsertBehavior that defines how the default row style will be set for the new row. This style is cells before the 'rowCellsCopyBehavior', so the 'rowCellsCopyBehavior' can be used to override the row\-wide style.{param}
{example}{code:csharp|title=C#}

          ws.InsertRow(3,
               Style.InsertBehavior.CopyAreaFromBelow,
               Style.RowInsertBehavior.Ignore);
        {code}
{code:vb.net|title=vb.net}

          ws.InsertRow(3, _
               Style.InsertBehavior.CopyAreaFromBelow, _
               Style.RowInsertBehavior.Ignore)
        {code}

{example}