Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IWorksheet Interface > Replace Method : Replace(String,String[],Boolean) Method
The string to be replaced.
Array of new values.
Indicates whether array should be inserted vertically.

Replace(String,String[],Boolean) Method

Replaces specified string with the specified array of string values.
Syntax
'Declaration
 
Overloads Sub Replace( _
   ByVal oldValue As String, _
   ByVal newValues() As String, _
   ByVal isVertical As Boolean _
) 
'Usage
 
Dim instance As IWorksheet
Dim oldValue As String
Dim newValues() As String
Dim isVertical As Boolean
 
instance.Replace(oldValue, newValues, isVertical)

Parameters

oldValue
The string to be replaced.
newValues
Array of new values.
isVertical
Indicates whether array should be inserted vertically.
Example
The following code snippet illustrates how to replace the string with array of string values.
string oldValue = "Find";
string[] newValues = { "X values", "Y values" };
sheet.Replace(oldValue, newValues, true);
AssemblyVersion

Syncfusion.XlsIO.Base: 16.3460.0.29

See Also