Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
C#
 public void InsertRows(int rowNumber, int rowCount, RowInsertBehavior rowCellsCopyBehavior, RowInsertBehavior rowCopyBehavior)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Sub InsertRows(ByVal rowNumber As Integer, ByVal rowCount 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:rowCount}The number of rows 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#}
Parameters
Param
rowNumber
rowNumber

The 0-based number of the row to insert.

Param
rowCount
rowCount

The number of rows to insert.

Param
rowCellsCopyBehavior
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
rowCopyBehavior
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.

Example
Code Block
csharp
csharp
titleC#


          ws.InsertRows(3,
               100,
               Style.InsertBehavior.CopyAreaFromBelow,
               Style.RowInsertBehavior.Ignore);
        
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}


          ws.InsertRows(3, _
               100, _
               Style.InsertBehavior.CopyAreaFromBelow, _
               Style.RowInsertBehavior.Ignore)
        
{code} {example}