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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetViewCollection Class
SheetViewCollection Members
Remove Method

User-Task Documentation

Removing a Sheet