Spread Windows Forms 15.0
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SearchHeaders Method / SearchHeaders(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Method
Index of sheet on which to search
String for which to search
Whether to search row headers instead of column headers
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
Index of row at which to start
Index of column at which to start
Index of row at which to end
Index of column at which to end
Index of row at which match is found
Index of column at which match is found


In This Topic
    SearchHeaders(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 header cells in the specified sheet for the specified string with the specified criteria, the start and end locations, and whether to include notes and tags.
    Syntax
    'Declaration
     
    
    Public Overloads Function SearchHeaders( _
       ByVal sheetIndex As Integer, _
       ByVal searchString As String, _
       ByVal searchRowHeaders As Boolean, _
       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 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 searchRowHeaders As Boolean
    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 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.SearchHeaders(sheetIndex, searchString, searchRowHeaders, caseSensitive, exactMatch, alternateSearch, useWildcards, includeCellText, includeNotes, includeTags, startRowIndex, startColumnIndex, endRowIndex, endColumnIndex, foundRowIndex, foundColumnIndex)

    Parameters

    sheetIndex
    Index of sheet on which to search
    searchString
    String for which to search
    searchRowHeaders
    Whether to search row headers instead of column headers
    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
    startRowIndex
    Index of row at which to start
    startColumnIndex
    Index of column at which to start
    endRowIndex
    Index of row at which to end
    endColumnIndex
    Index of column at which to end
    foundRowIndex
    Index of row at which match is found
    foundColumnIndex
    Index of column at which match is found
    See Also