GrapeCity.Documents.Excel.IRange.Replace

Replace Method

Replace(object, object, ReplaceOptions)

Search in formulas and replace. Using this method doesn't change either the selection or the active cell.

Declaration

int Replace(object what, object replacement, ReplaceOptions options = null)

Function Replace(what As Object, replacement As Object, Optional options As ReplaceOptions = Nothing) As Integer

Parameters

Type	Name	Description
object	what	The string you want to search for.
object	replacement	The replacement string.
ReplaceOptions	options	The replace options.

Returns

Type	Description
int	Number of cells that was replaced.

Examples

worksheet.Range["A1:A2"].Value = new object[,] {{"North"}, {"North"}};
int replacedCount = worksheet.Range["A1:A2"].Replace("North", "East");
object value = worksheet.Range["A1"].Value;