Spread WPF 17
GrapeCity.Windows.SpreadSheet.Data Namespace / Workbook Class / Search Method / Search(Int32,String,SearchFlags,SearchOrder,Int32,Int32) Method
The index of the sheet on which to search.
The string for which to search.
The search options.
Whether to conduct the search by column, row coordinates or row, column coordinates.
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,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 Sub Search( _
       ByVal sheetIndex As Integer, _
       ByVal searchString As String, _
       ByVal searchFlags As SearchFlags, _
       ByVal searchOrder As SearchOrder, _
       ByRef foundRowIndex As Integer, _
       ByRef foundColumnIndex As Integer _
    ) 
    'Usage
     
    Dim instance As Workbook
    Dim sheetIndex As Integer
    Dim searchString As String
    Dim searchFlags As SearchFlags
    Dim searchOrder As SearchOrder
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
     
    instance.Search(sheetIndex, searchString, searchFlags, searchOrder, foundRowIndex, foundColumnIndex)
    public void Search( 
       int sheetIndex,
       string searchString,
       SearchFlags searchFlags,
       SearchOrder searchOrder,
       out int foundRowIndex,
       out int foundColumnIndex
    )

    Parameters

    sheetIndex
    The index of the sheet on which to search.
    searchString
    The string for which to search.
    searchFlags
    The search options.
    searchOrder
    Whether to conduct the search by column, row coordinates or row, column coordinates.
    foundRowIndex
    The index of the row at which a match is found.
    foundColumnIndex
    The index of the column at which a match is found.
    See Also