Workbook.ReplaceAll Method

Replaces the data of all cells matching the specified criteria.

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

 Syntax

C#

public void ReplaceAll (
    string search,
    string replaceWith,
    Worksheet reference,
    FindWithin findWithin,
    bool matchCase,
    bool wholeCells
)

Visual Basic

Public Sub ReplaceAll( _
    search As String, _
    replaceWith As String, _
    reference As Worksheet, _
    findWithin As FindWithin, _
    matchCase As Boolean, _
    wholeCells As Boolean _
)

 Parameters

search

The text to search and replace.

replaceWith

The text to replace with.

reference

The worksheet to search.

findWithin

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

matchCase

Specifies whether the search should be case-sensitive.

wholeCells

Specifies whether to match entire cells only.