Spread Windows Forms 9.0 Product Documentation
GetSheetFromTag Method
Example 


Sheet from which to start (null to start from the beginning)
Tag object used to identify the sheet
Gets a sheet with a specific tag.
Syntax
'Declaration
 
Public Function GetSheetFromTag( _
   ByVal sheetToStart As SheetView, _
   ByVal tagToFind As Object _
) As SheetView
'Usage
 
Dim instance As FpSpread
Dim sheetToStart As SheetView
Dim tagToFind As Object
Dim value As SheetView
 
value = instance.GetSheetFromTag(sheetToStart, tagToFind)
public SheetView GetSheetFromTag( 
   SheetView sheetToStart,
   object tagToFind
)

Parameters

sheetToStart
Sheet from which to start (null to start from the beginning)
tagToFind
Tag object used to identify the sheet

Return Value

SheetView object containing the sheet with the specified tag
Example
This example hides the sheet with the specified tag.
fpSpread1.Sheets.Count = 3;
fpSpread1.Sheets[0].Tag = "Sheet1";
fpSpread1.Sheets[1].Tag = "Sheet2";
fpSpread1.Sheets[2].Tag = "Sheet3";

private void button1Click(object sender, System.EventArgs e) 
     FarPoint.Win.Spread.SheetView sv = fpSpread1.GetSheetFromTag(fpSpread1.Sheets[0], "Sheet3");
     sv.Visible = false;
End Sub
FpSpread1.Sheets.Count = 3
FpSpread1.Sheets(0).Tag = "Sheet1"
FpSpread1.Sheets(1).Tag = "Sheet2"
FpSpread1.Sheets(2).Tag = "Sheet3"

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
     Dim sv As FarPoint.Win.Spread.SheetView = FpSpread1.GetSheetFromTag(FpSpread1.Sheets(0), "Sheet3")
     sv.Visible = False
End Sub
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

FpSpread Class
FpSpread Members

User-Task Documentation

Adding a Tag to a Cell

 

 


Copyright © GrapeCity, inc. All rights reserved.