Search(Int32,String,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 As Integer, _
ByVal As String, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Integer, _
ByVal startColumnIndex As Integer, _
ByVal As Integer, _
ByVal endColumnIndex As Integer, _
ByRef 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 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.Search(sheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, includeNotes, includeTags, startRowIndex, startColumnIndex, endRowIndex, endColumnIndex, foundRowIndex, foundColumnIndex)
public SearchFoundFlags Search(
int ,
string ,
bool ,
bool ,
bool ,
bool ,
bool ,
bool ,
int ,
int startColumnIndex,
int ,
int endColumnIndex,
ref int ,
ref int 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
- 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
- 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