Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Search Method / Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32) Method
Index of sheet 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
Index of row at which to start
Index of column at which to start
Index of row at which match is found
Index of column at which match is found
Example


In This Topic
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,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.
    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 startRowIndex As Integer, _
       ByVal startColumnIndex As Integer, _
       ByRef foundRowIndex As Integer, _
       ByRef foundColumnIndex As Integer _
    ) As String
    '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 startRowIndex As Integer
    Dim startColumnIndex As Integer
    Dim foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As String
     
    value = instance.Search(sheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, startRowIndex, startColumnIndex, foundRowIndex, foundColumnIndex)
    public string Search( 
       int sheetIndex,
       string searchString,
       bool caseSensitive,
       bool exactMatch,
       bool alternateSearch,
       bool useWildcards,
       int startRowIndex,
       int startColumnIndex,
       ref int foundRowIndex,
       ref int foundColumnIndex
    )

    Parameters

    sheetIndex
    Index of sheet 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
    startRowIndex
    Index of row at which to start
    startColumnIndex
    Index of column at which to start
    foundRowIndex
    Index of row at which match is found
    foundColumnIndex
    Index of column at which match is found

    Return Value

    The entire string in which the specified string is found is returned.

    Also, the foundRowIndex and foundColumnIndex parameters return the row index and column index of the cell in which the string is found.

    Example
    This example uses the Search method.
    See Also