Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Inserts a row in the worksheet above the specified row.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Inserts a row in the worksheet above the specified row.{excerpt}
{signature:C#}
 public void InsertRow(int rowNumber, RowInsertBehavior rowCellsCopyBehavior)
Signature
{signature}{signature:vb.net
vb.net
}
Public Sub InsertRow(ByVal rowNumber As Integer, ByVal rowCellsCopyBehavior As RowInsertBehavior)
Parameters
{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}
{example}{code:csharp|title=C#}
  ws.InsertRow(3, Style.InsertBehavior.CopyAreaFromBelow);
{code}
{code:vb.net
|title=vb.net
}
ws.InsertRow(3, Style.InsertBehavior.CopyAreaFromBelow){code}

{example}
Param
rowNumberrowNumber

The 0-based number of the row to insert.

Param
rowCellsCopyBehaviorrowCellsCopyBehavior

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.

Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle