Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IWorksheet Interface > Replace Method : Replace(String,String,ExcelFindOptions) Method
The string to be replaced.
The string to replace all occurrences of oldValue.
Specifies the find options for the oldValue.

Replace(String,String,ExcelFindOptions) Method

Replaces string with the specified string value based on the given ExcelFindOptions.
Syntax
'Declaration
 
Overloads Sub Replace( _
   ByVal oldValue As String, _
   ByVal newValue As String, _
   ByVal findOptions As ExcelFindOptions _
) 
'Usage
 
Dim instance As IWorksheet
Dim oldValue As String
Dim newValue As String
Dim findOptions As ExcelFindOptions
 
instance.Replace(oldValue, newValue, findOptions)

Parameters

oldValue
The string to be replaced.
newValue
The string to replace all occurrences of oldValue.
findOptions
Specifies the find options for the oldValue.
Example
The following code snippet illustrates how to replace the string with another string.
string oldValue = "Find";
string newValue = "NewValue";
sheet.Replace(oldValue, newValue, ExcelFindOptions.MatchCase);
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also