.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

IWorkbook.Search(String, SearchOptions) Method

Performs a search in the current document using specified options.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll


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


Name Type Description
text String

A String representing the search text.

options SearchOptions

A SearchOptions instance containing required search options.


Type Description

An object implementing the IEnumerable interface which is the collection of cells that match the search term.


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.

See Also