自定义函数 JSA_A_BINARYSTRINGTOUINT8ARRAY 二进制字符串转Uint8

function JSA_A_BINARYSTRINGTOUINT8ARRAY(binaryString) { //二进制字符串 转 Uint8Array
    binaryString = binaryString.valueOf();
    let uint8Array = new Uint8Array(binaryString.length);
    
    for (let i = 0; i < binaryString.length; i++) {
        uint8Array[i] = binaryString.charCodeAt(i) & 0xFF;
    }
    
    return uint8Array
}

插入函数对话框、函数参数对话框：

加载宏文件function Workbook_Open(){}中添加以下代码。

Application.MacroOptions("JSA_A_BINARYSTRINGTOUINT8ARRAY", "二进制字符串 转 Uint8Array", undefined, undefined, undefined, undefined, 14, undefined, undefined, undefined, ['二进制字符串。']);