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
)
Public Function ReplaceAll (
oldValue As String,
oldStyle As CellStyle,
newValue As String,
newStyle As CellStyle
) As Integer
public:
int ReplaceAll(
String^ oldValue,
CellStyle^ oldStyle,
String^ newValue,
CellStyle^ newStyle
)
member ReplaceAll :
oldValue : string *
oldStyle : CellStyle *
newValue : string *
newStyle : CellStyle -> int
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