Click or drag to resize

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
)

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