Find
function Find(
What: string | "undefined" = null,
After: ApiRange = null,
LookIn: XlFindLookIn = null,
LookAt: XlLookAt = null,
SearchOrder: XlSearchOrder = null,
SearchDirection: XlSearchDirection = null,
MatchCase: boolean = null,
): ApiRange | "null"Description
Finds specific information in the current range.
Parameters
- What
string | "undefined"default: null The data to search for.
The cell after which you want the search to begin. If this argument is not specified, the search starts after the cell in the upper-left corner of the range.
Search data type (formulas or values).
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".
Returns
ApiRange | "null"Try 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 oSearchData = {
What: "200",
After: oWorksheet.GetRange("B1"),
LookIn: "xlValues",
LookAt: "xlWhole",
SearchOrder: "xlByColumns",
SearchDirection: "xlNext",
MatchCase: true
};
var oSearchRange = oRange.Find(oSearchData);
oSearchRange.SetFillColor(Api.CreateColorFromRGB(255, 213, 191));