Workbook.Find Method

Performs a search for a cell containing the specified text, using the specified criteria.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public Cell Find (
    string search,
    Cell reference,
    FindWithin findWithin,
    LookIn lookIn,
    SearchOrder order,
    SearchDirection direction,
    bool matchCase,
    bool wholeCells
)

Visual Basic

Public Function Find( _
    search As String, _
    reference As Cell, _
    findWithin As FindWithin, _
    lookIn As LookIn, _
    order As SearchOrder, _
    direction As SearchDirection, _
    matchCase As Boolean, _
    wholeCells As Boolean _
) As Cell

 Parameters

search

The text to search.

reference

The cell to start the search from.

findWithin

The target of the search - the referenced worksheet or the entire workbook.

lookIn

Specifies whether to search in the cell's formula or value.

order

The search order - horizontal or vertical.

direction

The search direction - forward or backward.

matchCase

Specifies whether the search should be case-sensitive.

wholeCells

Specifies whether to match entire cells only.

 Return Value

A Cell object representing the found cell, or null (Nothing in Visual Basic), if the text was not found.