Spread WPF 17
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / Search Method / Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,SheetArea,Int32,Int32,Int32,Int32,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 to start.
The index of the column at which to start.
The index of the row at which to stop searching.
The index of the column at which to stop searching.
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,Int32,Int32,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 start and end location, 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, _
       ByVal rowStart As Integer, _
       ByVal columnStart As Integer, _
       ByVal rowEnd As Integer, _
       ByVal columnEnd As Integer, _
       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 rowStart As Integer
    Dim columnStart As Integer
    Dim rowEnd As Integer
    Dim columnEnd As Integer
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As SearchFoundFlags
     
    value = instance.Search(sheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, rowEnd, columnEnd, 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.
    rowStart
    The index of the row at which to start.
    columnStart
    The index of the column at which to start.
    rowEnd
    The index of the row at which to stop searching.
    columnEnd
    The index of the column at which to stop searching.
    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

    Returns the found flags.
    See Also