Spread Windows Forms 9.0 Product Documentation
Remove Method (SheetViewCollection)
Example 


Sheet (SheetView object) to remove from the collection
Removes the specified sheet from the collection.
Syntax
'Declaration
 
Public Overridable Sub Remove( _
   ByVal sheetView As SheetView _
) 
'Usage
 
Dim instance As SheetViewCollection
Dim sheetView As SheetView
 
instance.Remove(sheetView)
public virtual void Remove( 
   SheetView sheetView
)

Parameters

sheetView
Sheet (SheetView object) to remove from the collection
Example
This example removes the specified sheet from the collection.
System.Collections.ArrayList coll = new System.Collections.ArrayList(3); 
FarPoint.Win.Spread.SheetView Sheet1 = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.SheetView Sheet2 = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.SheetView Sheet3 = new FarPoint.Win.Spread.SheetView();
Sheet1.SheetName = "One";
Sheet2.SheetName = "Two";
Sheet3.SheetName = "Three";
coll.AddRange(new Object[] {Sheet1, Sheet2, Sheet3});
fpSpread1.Sheets.AddRange(coll);
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.Sheets.Remove(Sheet1);
Dim coll As New System.Collections.ArrayList(3)
Dim Sheet1 As New FarPoint.Win.Spread.SheetView()
Dim Sheet2 As New FarPoint.Win.Spread.SheetView()
Dim Sheet3 As New FarPoint.Win.Spread.SheetView()
Sheet1.SheetName = "One"
Sheet2.SheetName = "Two"
Sheet3.SheetName = "Three"
coll.AddRange(New Object() {Sheet1, Sheet2, Sheet3})
FpSpread1.Sheets.AddRange(coll)
FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
FpSpread1.Sheets.Remove(Sheet1)
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

See Also

Reference

SheetViewCollection Class
SheetViewCollection Members
RemoveAt Method

User-Task Documentation

Removing a Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.