'Declaration Public Overloads Function Search( _ ByVal startSheetIndex As Integer, _ ByVal endSheetIndex As Integer, _ ByVal searchString As String, _ ByVal searchFlags As SearchFlags, _ ByVal searchOrder As SearchOrder, _ ByVal searchTarget As SearchFoundFlags, _ ByVal sheetArea As SheetArea, _ ByVal rowStart As Integer, _ ByVal columnStart As Integer, _ ByVal rowEnd As Integer, _ ByVal columnEnd As Integer, _ ByRef foundSheetIndex As Integer, _ ByRef foundRowIndex As Integer, _ ByRef foundColumnIndex As Integer _ ) As SearchFoundFlags
'Usage Dim instance As GcSpreadSheet Dim startSheetIndex As Integer Dim endSheetIndex As Integer Dim searchString As String Dim searchFlags As SearchFlags Dim searchOrder As SearchOrder Dim searchTarget As SearchFoundFlags Dim sheetArea As SheetArea Dim rowStart As Integer Dim columnStart As Integer Dim rowEnd As Integer Dim columnEnd As Integer Dim foundSheetIndex As Integer Dim foundRowIndex As Integer Dim foundColumnIndex As Integer Dim value As SearchFoundFlags value = instance.Search(startSheetIndex, endSheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, rowEnd, columnEnd, foundSheetIndex, foundRowIndex, foundColumnIndex)
public SearchFoundFlags Search( int startSheetIndex, int endSheetIndex, string searchString, SearchFlags searchFlags, SearchOrder searchOrder, SearchFoundFlags searchTarget, SheetArea sheetArea, int rowStart, int columnStart, int rowEnd, int columnEnd, out int foundSheetIndex, out int foundRowIndex, out int foundColumnIndex )
Parameters
- startSheetIndex
- Index of the sheet on which to start the search.
- endSheetIndex
- Index of the sheet on which to end the search.
- searchString
- The string for which to search.
- searchFlags
- The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies the search options.
- searchOrder
- The GrapeCity.Windows.SpreadSheet.Data.SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
- searchTarget
- The GrapeCity.Windows.SpreadSheet.Data.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.
- rowStart
- The index of the row at which to start.
- columnStart
- The index of the column at which to start.
- rowEnd
- The index of the row at which to end.
- columnEnd
- The index of the column at which to end.
- foundSheetIndex
- The index of the sheet at which a match is found.
- foundRowIndex
- The row index at which a match is found.
- foundColumnIndex
- The column index at which a match is found.
Return Value
A GrapeCity.Windows.SpreadSheet.Data.SearchFoundFlags enumeration that specifies what is matched.