FarPoint.Win.Spread
SheetIndex Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SearchDialog Class : SheetIndex Property


Gets or sets the index of the sheet to search.

Syntax

Visual Basic (Declaration) 
Public Overridable Property SheetIndex As Integer
Visual Basic (Usage)Copy Code
Dim instance As SearchDialog
Dim value As Integer
 
instance.SheetIndex = value
 
value = instance.SheetIndex
C# 
public virtual int SheetIndex {get; set;}

Return Value

Integer index of sheet to search

Example

C#Copy Code
fpSpread1.SearchWithDialog("");

fpSpread1.SearchDialog.AlternateSearch = true;

fpSpread1.SearchDialog.CaseSensitive = false;

fpSpread1.SearchDialog.ExactMatch = false;

fpSpread1.SearchDialog.SearchString = "155";

fpSpread1.SearchDialog.SheetIndex = 0;

fpSpread1.SearchDialog.StartColumnIndex = 0;

fpSpread1.SearchDialog.StartRowIndex = 0;

fpSpread1.SearchDialog.UseWildcards = false;
Visual BasicCopy Code
FpSpread1.SearchWithDialog("")
FpSpread1.SearchDialog.AlternateSearch = True
FpSpread1.SearchDialog.CaseSensitive = False
FpSpread1.SearchDialog.ExactMatch = False
FpSpread1.SearchDialog.SearchString = "155"
FpSpread1.SearchDialog.SheetIndex = 0
FpSpread1.SearchDialog.StartColumnIndex = 0
FpSpread1.SearchDialog.StartRowIndex = 0
FpSpread1.SearchDialog.UseWildcards = False

Remarks

The sheet index is zero-based, so the first sheet has an index of 0.

See Also