Add Method (Rows)

Adds a new row or range of rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub Add( _
   ByVal index As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As Rows
Dim index As Integer
Dim count As Integer
 
instance.Add(index, count)

public void Add( 
   int index,
   int count
)

Parameters

index: Row index at which to start
count: Number of rows to add

Example

This example adds five rows to the active sheet.

fpSpread1.ActiveSheet.Rows.Add(0, 5);

listBox1.Items.Add(fpSpread1.ActiveSheet.Rows.Count.ToString());

Visual Basic

FpSpread1.ActiveSheet.Rows.Add(0, 5)

ListBox1.Items.Add(FpSpread1.ActiveSheet.Rows.Count.ToString())

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

Rows Class
Rows Members

User-Task Documentation

Adding a Row or Column