Spread Windows Forms 12.0 Product Documentation
GetSheetFromTag Method

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : GetSheetFromTag Method
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.
Public Function GetSheetFromTag( _
   ByVal sheetToStart As SheetView, _
   ByVal tagToFind As Object _
) As SheetView
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


Sheet from which to start (null to start from the beginning)
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.
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
See Also


FpSpread Class
FpSpread Members

User-Task Documentation

Adding a Tag to a Cell