Workbook.FindAll Method

Finds and returns all cells containing the specified text, using the specified criteria.

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

 Syntax

C#

public IEnumerable<Cell> FindAll (
    string search,
    Worksheet reference,
    FindWithin findWithin,
    LookIn lookIn,
    SearchOrder order,
    SearchDirection direction,
    bool matchCase,
    bool wholeCells
)

Visual Basic

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

 Parameters

search

The text to search.

reference

The worksheet to search.

findWithin

The target of the search - the specified 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

An enumerable containing the found cells.