Spread WPF 17
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / Search Method / Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,Int32,Int32) Method
The index of the sheet on which to search.
The string for which to search.
The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies the options of the search.
The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
The GrapeCity.Windows.SpreadSheet.Data.SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tags, or text.
The index of the row at which a match is found.
The index of the column at which a match is found.


In This Topic
    Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,Int32,Int32) Method
    In This Topic
    Searches the text in the cells in the specified sheet for the specified string with the specified criteria.
    Syntax
    'Declaration
     
    Public Overloads Function Search( _
       ByVal sheetIndex As Integer, _
       ByVal searchString As String, _
       ByVal searchFlags As SearchFlags, _
       ByVal searchOrder As SearchOrder, _
       ByVal searchTarget As SearchFoundFlags, _
       ByRef foundRowIndex As Integer, _
       ByRef foundColumnIndex As Integer _
    ) As SearchFoundFlags
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim sheetIndex As Integer
    Dim searchString As String
    Dim searchFlags As SearchFlags
    Dim searchOrder As SearchOrder
    Dim searchTarget As SearchFoundFlags
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As SearchFoundFlags
     
    value = instance.Search(sheetIndex, searchString, searchFlags, searchOrder, searchTarget, foundRowIndex, foundColumnIndex)

    Parameters

    sheetIndex
    The index of the sheet on which to search.
    searchString
    The string for which to search.
    searchFlags
    The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies the options of the search.
    searchOrder
    The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
    searchTarget
    The GrapeCity.Windows.SpreadSheet.Data.SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tags, or text.
    foundRowIndex
    The index of the row at which a match is found.
    foundColumnIndex
    The index of the column at which a match is found.

    Return Value

    The found flags.
    See Also