Click or drag to resize

XlsWorksheet ReplaceAll Method (String, CellStyle, String, CellStyle)

Replaces cells' values with new data and style.

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,
	CellStyle oldStyle,
	string newValue,
	CellStyle newStyle
)

Parameters

oldValue
Type: System String
String value to replace.
oldStyle
Type: Spire.Xls CellStyle
Cell style to replace.
newValue
Type: System String
New value for the range with specified string.
newStyle
Type: Spire.Xls CellStyle
New cell style for the range.

Return Value

Type: Int32
See Also