Replace
function Replace(
What: string | "undefined" = null,
Replacement: string = null,
LookAt: XlLookAt = null,
SearchOrder: XlSearchOrder = null,
SearchDirection: XlSearchDirection = null,
MatchCase: boolean = null,
ReplaceAll: boolean = null,
): voidDescription
Replaces specific information to another one in a range.
Parameters
- What
string | "undefined"default: null The data to search for.
- Replacement
stringdefault: null The replacement string.
Specifies whether the whole search text or any part of the search text is matched.
Range search order - by rows or by columns.
Range search direction - next match or previous match.
- MatchCase
booleandefault: null Case sensitive or not. The default value is "false".
- ReplaceAll
booleandefault: null Specifies if all the found data will be replaced or not. The default value is "true".
Returns
voidTry It
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("B1").SetValue(2014);
oWorksheet.GetRange("C1").SetValue(2015);
oWorksheet.GetRange("D1").SetValue(2016);
oWorksheet.GetRange("A2").SetValue("Projected Revenue");
oWorksheet.GetRange("A3").SetValue("Estimated Costs");
oWorksheet.GetRange("A4").SetValue("Cost price");
oWorksheet.GetRange("B2").SetValue(200);
oWorksheet.GetRange("B3").SetValue(250);
oWorksheet.GetRange("B4").SetValue(50);
oWorksheet.GetRange("C2").SetValue(200);
oWorksheet.GetRange("C3").SetValue(260);
oWorksheet.GetRange("C4").SetValue(120);
oWorksheet.GetRange("D2").SetValue(200);
oWorksheet.GetRange("D3").SetValue(200);
oWorksheet.GetRange("D4").SetValue(160);
var oRange = oWorksheet.GetRange("A2:D4");
var oReplaceData = {
What: "200",
Replacement: "0",
LookAt: "xlWhole",
SearchOrder: "xlByColumns",
SearchDirection: "xlNext",
MatchCase: true,
ReplaceAll: true
};
oRange.Replace(oReplaceData);