MIDB

MIDB(arg1, arg2, arg3) → { string }

Extracts the characters from the specified string starting from any position and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

Parameters:

Name Type Description
arg1 string

The text string from which to extract the characters.

arg2 number

The position of the first character to extract. The first text character is 1.

arg3 number

A number of the characters to extract, based on bytes.

Returns:

Type
string

Example

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

Resulting document