Remove Method (Rows)

Removes a row or range of rows.

Syntax

Visual Basic
C#

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

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

public void Remove( 
   int index,
   int count
)

Parameters

index: Index of row at which to start
count: Number of rows to remove

Example

This example removes five rows from the active sheet.

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

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

Visual Basic

FpSpread1.ActiveSheet.Rows.Remove(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
Remove Method (Row Class)