Spread WPF 17
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / Search Method / Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,SheetArea,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 search options.
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 area of the sheet to search.
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,SheetArea,Int32,Int32) Method
    In This Topic
    Searches the text in the cells in the specified sheet for the specified string with the specified criteria and whether to search notes and tags as well.
    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, _
       ByVal sheetArea As SheetArea, _
       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 sheetArea As SheetArea
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As SearchFoundFlags
     
    value = instance.Search(sheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, 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 search options.
    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.
    sheetArea
    The area of the sheet to search.
    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