IWorkbook.Search(String) Method

Performs a search in the current document using the default parameters.

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

IEnumerable<Cell> Search(
    string text
)

Function Search(
    text As String
) As IEnumerable(Of Cell)

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.