FIND

FIND(arg1, arg2, arg3) → { number }

Returns the starting position of one text string within another text string. This function is case-sensitive.

Parameters:

Name Type Description
arg1 string

The text to find. Use double quotes (empty text) to match the first character in the search string. Wildcard characters are not allowed.

arg2 string

The text containing the text to find.

arg3 number

Specifies the character at which to start the search. The first character in the search string is character number 1. If omitted, this parameter is equal to 1.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FIND("line", "Online Office"));
builder.SaveFile("xlsx", "FIND.xlsx");
builder.CloseFile();

Resulting document