IWorkbook.Search(String) Method
Performs a search in the current document using the default parameters.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
text | String | A String representing the search text. |
Returns
Type | Description |
---|---|
IEnumerable<Cell> | An object implementing the IEnumerable interface which is the collection of cells that match the search term. |
Remarks
Use the Search method to perform a search in the current document with the default parameters listed in the table below.
Option | Default Value |
---|---|
Look In | Values and Formulas |
Search Direction | By Rows |
Match Case | False |
Match Entire Cell Contents | False |
To restrict a search to the active worksheet or even a cell range, use the Worksheet.Search or CellRange.Search methods. For more information about the search functionality in the SpreadsheetControl, refer to the Find and Replace article.