XlsWorksheet
ReplaceAll Method (String, String, Boolean)
|
Replaces all occurrences of a specified value with a new value in the worksheet.
Namespace:
Spire.Xls.Core.Spreadsheet
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public int ReplaceAll(
string oldValue,
string newValue,
bool matchCase
)
Public Function ReplaceAll (
oldValue As String,
newValue As String,
matchCase As Boolean
) As Integer
public:
int ReplaceAll(
String^ oldValue,
String^ newValue,
bool matchCase
)
member ReplaceAll :
oldValue : string *
newValue : string *
matchCase : bool -> int
Parameters
-
oldValue
-
Type:
System
String
The value to be replaced.
-
newValue
-
Type:
System
String
The new value to replace with.
-
matchCase
-
Type:
System
Boolean
Whether the replacement should be case-sensitive.
Return Value
Type:
Int32
The number of occurrences replaced.
See Also