Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / Search Method / Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Method
Sheet index on which to search
String for which to search
Whether the search considers the case of the letters in the search string
Whether the search considers only an exact match
Whether the search goes by alternate coordinates of column, row (instead of row, column)
Whether the search considers wildcard characters (*, ?) in the search string
Whether the search includes the content in the cell
Whether the search includes the content in the cell notes
Whether the search includes the content in the cell tags or their string representations
Specifies whether to search the specified block of cells only
Row Index at which to start
Column index at which to start
Row Index at which to end
Column index at which to end
Row Index at which match is found
Column index at which match is found


In This Topic
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Method
    In This Topic
    Searches the text in the specified range of 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 caseSensitive As Boolean, _
       ByVal exactMatch As Boolean, _
       ByVal alternateSearch As Boolean, _
       ByVal useWildcards As Boolean, _
       ByVal includeCellText As Boolean, _
       ByVal includeNotes As Boolean, _
       ByVal includeTags As Boolean, _
       ByVal searchAsBlockRange As Boolean, _
       ByVal startRowIndex As Integer, _
       ByVal startColumnIndex As Integer, _
       ByVal endRowIndex As Integer, _
       ByVal endColumnIndex As Integer, _
       ByRef foundRowIndex As Integer, _
       ByRef foundColumnIndex As Integer _
    ) As SearchFoundFlags
    'Usage
     
    
    Dim instance As FpSpread
    Dim sheetIndex As Integer
    Dim searchString As String
    Dim caseSensitive As Boolean
    Dim exactMatch As Boolean
    Dim alternateSearch As Boolean
    Dim useWildcards As Boolean
    Dim includeCellText As Boolean
    Dim includeNotes As Boolean
    Dim includeTags As Boolean
    Dim searchAsBlockRange As Boolean
    Dim startRowIndex As Integer
    Dim startColumnIndex As Integer
    Dim endRowIndex As Integer
    Dim endColumnIndex As Integer
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As SearchFoundFlags
     
    value = instance.Search(sheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, includeCellText, includeNotes, includeTags, searchAsBlockRange, startRowIndex, startColumnIndex, endRowIndex, endColumnIndex, foundRowIndex, foundColumnIndex)

    Parameters

    sheetIndex
    Sheet index on which to search
    searchString
    String for which to search
    caseSensitive
    Whether the search considers the case of the letters in the search string
    exactMatch
    Whether the search considers only an exact match
    alternateSearch
    Whether the search goes by alternate coordinates of column, row (instead of row, column)
    useWildcards
    Whether the search considers wildcard characters (*, ?) in the search string
    includeCellText
    Whether the search includes the content in the cell
    includeNotes
    Whether the search includes the content in the cell notes
    includeTags
    Whether the search includes the content in the cell tags or their string representations
    searchAsBlockRange
    Specifies whether to search the specified block of cells only
    startRowIndex
    Row Index at which to start
    startColumnIndex
    Column index at which to start
    endRowIndex
    Row Index at which to end
    endColumnIndex
    Column index at which to end
    foundRowIndex
    Row Index at which match is found
    foundColumnIndex
    Column index at which match is found
    See Also