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

function JSA_A_UINT8ARRAYTOBINARYSTRING(uint8Array) { //Uint8Array 转 二进制字符串
    uint8Array = (Array.isArray(uint8Array.valueOf()) || (uint8Array instanceof Uint8Array)) ? Array.from(uint8Array.valueOf()).flat(Infinity) : [uint8Array.valueOf()];
    let binaryString = "";
    let i = 0;
    
    while (i < uint8Array.length) {
        binaryString = binaryString + String.fromCharCode(uint8Array[i++]);
    }
    
    return binaryString
}

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

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

Application.MacroOptions("JSA_A_UINT8ARRAYTOBINARYSTRING", "Uint8Array 转 二进制字符串", undefined, undefined, undefined, undefined, 14, undefined, undefined, undefined, ['Uint8Array，也可以是单行或多行数组。']);