GetSheetFromTag Method

Visual Basic
C#

'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

This example hides the sheet with the specified tag.

C#

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

Visual Basic

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

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

FpSpread Class
FpSpread Members

User-Task Documentation

Adding a Tag to a Cell