AddRows Method (SheetView)

Adds a row or rows to the data model for a sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub AddRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim count As Integer
 
instance.AddRows(row, count)

public virtual void AddRows( 
   int row,
   int count
)

Parameters

row: Row index where the new rows are to be added
count: Number of rows to be added

Example

This example adds two rows to the active sheet.

DialogResult dlg;
fpSpread1.ActiveSheet.Rows.Count = 4;
dlg = MessageBox.Show("Do you want to add some rows?", "AddRows", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
    fpSpread1.ActiveSheet.AddRows(0, 2);
}

Visual Basic

Dim dlg As DialogResult
FpSpread1.ActiveSheet.Rows.Count = 4
dlg = MessageBox.Show("Do you want to add some rows?", "AddRows", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
    FpSpread1.ActiveSheet.AddRows(0, 2)
End If

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members

User-Task Documentation

Adding a Row or Column