'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, _ ByRef foundString As String _ ) 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 foundString As String Dim value As SearchFoundFlags value = instance.Search(startSheetIndex, endSheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, rowEnd, columnEnd, foundSheetIndex, foundRowIndex, foundColumnIndex, foundString)
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, out string foundString )
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 row index at which to start.
- columnStart
- The column index at which to start.
- rowEnd
- The row index at which to stop searching.
- columnEnd
- The column index at which to stop searching.
- foundSheetIndex
- The index of the sheet at which a match is found.
- foundRowIndex
- The index of the row at which a match is found.
- foundColumnIndex
- The index of the column at which a match is found.
- foundString
- The found string.
Return Value
A GrapeCity.Windows.SpreadSheet.Data.SearchFoundFlags enumeration that specifies what is matched.