Workbook.Replace Method

Replaces the data of the specified cell if it matches the specified criteria and returns the next matching cell.

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

 Syntax

C#

public Cell Replace (
    string search,
    string replaceWith,
    Cell cell,
    FindWithin findWithin,
    SearchOrder order,
    SearchDirection direction,
    bool matchCase,
    bool wholeCells
)

Visual Basic

Public Function Replace( _
    search As String, _
    replaceWith As String, _
    cell As Cell, _
    findWithin As FindWithin, _
    order As SearchOrder, _
    direction As SearchDirection, _
    matchCase As Boolean, _
    wholeCells As Boolean _
) As Cell

 Parameters

search

The text to search and replace.

replaceWith

The value to replace with.

cell

The cell containing the data to replace.

findWithin

The target of the replace operation - the referenced worksheet or the entire workbook.

order

The replace order - horizontal or vertical.

direction

The replace direction - forward or backward.

matchCase

Specifies whether the match should be case-sensitive.

wholeCells

Specifies whether to match entire cells only.

 Return Value

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