Calc .NET Class Library
Show/Hide TOC

# WorkbookReplace(IListString, IListString, FindOptions) Method

Replaces all occurrences of the specified oldText with newText.

## Definition

Namespace: Independentsoft.Office.Spreadsheet
Assembly: Independentsoft.Calc (in Independentsoft.Calc.dll) Version: 3.0.520.1+c6c593d5629a051e0af021b238c5d69d764f9686
C#

    public int Replace(
    	IList<string> oldText,
    	IList<string> newText,
    	FindOptions options
    )

VB

    Public Function Replace (
    	oldText As IList(Of String),
    	newText As IList(Of String),
    	options As FindOptions
    ) As Integer

#### Parameters

oldText IList String
  An array of strings to replace.
newText IList String
  An array of strings that replaces oldText.
options FindOptions
  The options of the search.

#### Return Value

Int32
The number of replaced occurrences.

## See Also

#### Reference

Workbook Class
Replace Overload
Independentsoft.Office.Spreadsheet Namespace