GrapeCity.Xaml.SpreadSheet.Data
Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,SheetArea,Int32,Int32) Method


GrapeCity.Xaml.SpreadSheet.Data Namespace > Workbook Class > Search Method : Search(Int32,String,SearchFlags,SearchOrder,SearchFoundFlags,SheetArea,Int32,Int32) Method
The index of the sheet on which to search.
The string for which to search.
The SearchFlags enumeration that specifies the options of the search.
The SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
The SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tags, or text.
The area of the sheet to search.
The index of the row at which a match is found.
The index of the column at which a match is found.
Searches the text in the cells in the specified sheet for the specified string with the specified criteria and whether to search notes and tags as well.
Syntax
'Declaration
 
Public Overloads Function Search( _
   ByVal sheetIndex As Integer, _
   ByVal searchString As String, _
   ByVal searchFlags As SearchFlags, _
   ByVal searchOrder As SearchOrder, _
   ByVal searchTarget As SearchFoundFlags, _
   ByVal sheetArea As SheetArea, _
   ByRef foundRowIndex As Integer, _
   ByRef foundColumnIndex As Integer _
) As SearchFoundFlags
'Usage
 
Dim instance As Workbook
Dim sheetIndex As Integer
Dim searchString As String
Dim searchFlags As SearchFlags
Dim searchOrder As SearchOrder
Dim searchTarget As SearchFoundFlags
Dim sheetArea As SheetArea
Dim foundRowIndex As Integer
Dim foundColumnIndex As Integer
Dim value As SearchFoundFlags
 
value = instance.Search(sheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, foundRowIndex, foundColumnIndex)

Parameters

sheetIndex
The index of the sheet on which to search.
searchString
The string for which to search.
searchFlags
The SearchFlags enumeration that specifies the options of the search.
searchOrder
The SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
searchTarget
The SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tags, or text.
sheetArea
The area of the sheet to search.
foundRowIndex
The index of the row at which a match is found.
foundColumnIndex
The index of the column at which a match is found.

Return Value

The found flags.
See Also

Reference

Workbook Class
Workbook Members
Overload List