Spread Windows Forms 10.0 Product Documentation
Find Method (SheetViewCollection)
Example 


Name of sheet (SheetView object) to find
Searches the collection for a sheet with the specified name.
Syntax
'Declaration
 
Public Function Find( _
   ByVal name As String _
) As SheetView
'Usage
 
Dim instance As SheetViewCollection
Dim name As String
Dim value As SheetView
 
value = instance.Find(name)
public SheetView Find( 
   string name
)

Parameters

name
Name of sheet (SheetView object) to find

Return Value

SheetView object containing the sheet
Example
This example finds the specified sheet in 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();
coll.AddRange(new Object[] {Sheet1, Sheet2, Sheet3});
fpSpread1.Sheets.AddRange(coll);
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
listBox1.Items.Add(fpSpread1.Sheets.Find("Sheet1").ToString());
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()
coll.AddRange(New Object() {Sheet1, Sheet2, Sheet3})
FpSpread1.Sheets.AddRange(coll)
FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
ListBox1.Items.Add(FpSpread1.Sheets.Find("Sheet1").ToString())
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

 

 


Copyright © GrapeCity, inc. All rights reserved.