TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

BASE

BASE(arg1, arg2, arg3) → { number | string | boolean }

Converts a number into a text representation with the given radix (base).

Parameters:

Name Type Description
arg1 number

Is the number that you want to convert.

arg2 number

Is the base Radix that you want to convert the number into.

arg3 number

Is the minimum length of the returned string. If omitted leading zeros are not added.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.BASE(5, 2, 5));
builder.SaveFile("xlsx", "BASE.xlsx");
builder.CloseFile();

Resulting document