Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / SearchHeaders Method / SearchHeaders(Int32,String,Boolean,Int32,Int32) Method
Index of sheet on which to search
String for which to search
Whether to search row headers instead of column headers
Index of row at which match is found
Index of column at which match is found
Example


In This Topic
    SearchHeaders(Int32,String,Boolean,Int32,Int32) Method
    In This Topic
    Searches the text in the header cells in the specified sheet for the specified string with the specified criteria.
    Syntax
    'Declaration
     
    
    Public Overloads Function SearchHeaders( _
       ByVal sheetIndex As Integer, _
       ByVal searchString As String, _
       ByVal searchRowHeaders As Boolean, _
       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 foundRowIndex As Integer
    Dim foundColumnIndex As Integer
    Dim value As SearchFoundFlags
     
    value = instance.SearchHeaders(sheetIndex, searchString, searchRowHeaders, 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
    foundRowIndex
    Index of row at which match is found
    foundColumnIndex
    Index of column at which match is found

    Return Value

    SearchFoundFlags setting, that specifies in what type of object the string was 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 SearchHeaders method.
    See Also