HEX2BIN
function HEX2BIN(arg1: any = null, arg2: any = null): number | string | booleanDescription
Converts a Hexadecimal number to binary.
Parameters
- arg1
anydefault: null Is the hexadecimal number you want to convert.
- arg2
anydefault: null Is the number of characters to use.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.HEX2BIN("FFFFFFFF9C"));