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 As Integer, _
ByVal As String, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Integer, _
ByVal startColumnIndex As Integer, _
ByRef 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)
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
See Also