XlsRange
Replace Method (String,
String
, Boolean)
|
Replaces cells' values with new data.
Namespace:
Spire.Xls.Core.Spreadsheet
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void Replace(
string oldValue,
string[] newValues,
bool isVertical
)
Public Sub Replace (
oldValue As String,
newValues As String(),
isVertical As Boolean
)
public:
void Replace(
String^ oldValue,
array<String^>^ newValues,
bool isVertical
)
member Replace :
oldValue : string *
newValues : string[] *
isVertical : bool -> unit
Parameters
-
oldValue
-
Type:
System
String
Value to search for.
-
newValues
-
Type:
System
String
The replacement value.
-
isVertical
-
Type:
System
Boolean
Indicates whether to insert values vertically or horizontally.
See Also