TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

BITLSHIFT

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

Returns a number shifted left by shift_amount bits.

Parameters:

Name Type Description
arg1 number

Is the decimal representation of the binary number you want to evaluate.

arg2 number

Is the number of bits that you want to shift Number left by.

Returns:

Type
number | string | boolean

Example

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

Resulting document