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


The index of the sheet on which to search.
The string for which to search.
The search options.
Whether to conduct the search by column, row coordinates or row, column coordinates.
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.
Syntax
'Declaration
 
Public Overloads Sub Search( _
   ByVal sheetIndex As Integer, _
   ByVal searchString As String, _
   ByVal searchFlags As SearchFlags, _
   ByVal searchOrder As SearchOrder, _
   ByRef foundRowIndex As Integer, _
   ByRef foundColumnIndex As Integer _
) 
'Usage
 
Dim instance As Workbook
Dim sheetIndex As Integer
Dim searchString As String
Dim searchFlags As SearchFlags
Dim searchOrder As SearchOrder
Dim foundRowIndex As Integer
Dim foundColumnIndex As Integer
 
instance.Search(sheetIndex, searchString, searchFlags, searchOrder, foundRowIndex, foundColumnIndex)
public void Search( 
   int sheetIndex,
   string searchString,
   SearchFlags searchFlags,
   SearchOrder searchOrder,
   out int foundRowIndex,
   out int foundColumnIndex
)

Parameters

sheetIndex
The index of the sheet on which to search.
searchString
The string for which to search.
searchFlags
The search options.
searchOrder
Whether to conduct the search by column, row coordinates or row, column coordinates.
foundRowIndex
The index of the row at which a match is found.
foundColumnIndex
The index of the column at which a match is found.
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

Workbook Class
Workbook Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options