RemoveAt Method (SheetViewCollection)

Removes a sheet (SheetView object) from the collection at the specified index.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Sub RemoveAt( _
   ByVal index As Integer _
)

'Usage
 
Dim instance As SheetViewCollection
Dim index As Integer
 
instance.RemoveAt(index)

public new void RemoveAt( 
   int index
)

Parameters

index: Zero-based index of the sheet to remove from the collection

Exceptions

Exception	Description
System.IndexOutOfRangeException	Specified sheet index is not valid; must be between 0 and the total number of sheets in the collection

Example

This example removes a sheet from the collection at the specified index.

fpSpread1.Sheets.Count = 3;
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.Sheets.RemoveAt(1);

Visual Basic

FpSpread1.Sheets.Count = 3
FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
FpSpread1.Sheets.RemoveAt(1)

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

SheetViewCollection Class
SheetViewCollection Members
Remove Method

User-Task Documentation

Removing a Sheet