IWorkbook.Search(String, SearchOptions) Method

Performs a search in the current document using specified options.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

IEnumerable<Cell> Search(
    string text,
    SearchOptions options
)

VB.NET

Function Search(
    text As String,
    options As SearchOptions
) As IEnumerable(Of Cell)

Parameters

Name	Type	Description
text	String	A String representing the search text.
options	SearchOptions	A SearchOptions instance containing required search options.

Returns

Type	Description
IEnumerable<Cell>	An object implementing the IEnumerable interface which is the collection of cells that match the search term.

Remarks

To restrict a search to the active worksheet or 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.