xlsx.full.js实现将excle导入表格转为二维数组的解决方案

   const reader = new FileReader();
        reader.readAsBinaryString(file);
        reader.onload = function (e) {
            const data = e.target.result;
            const zzexcel = window.XLS.read(data, {
                type: 'binary'
            });
            const newData = window.XLS.utils.sheet_to_csv(zzexcel.Sheets[zzexcel.SheetNames[0]]);
            //替换转化csv文件的换行符;
            var str = newData.replace(/[\n]/g, ",");
            str = str.substring(0, str.lastIndexOf(','));
            var a = str.split(",");
            var result = transArr(a, 4);//输出具体名称;
            console.log(result);
            var b = JSON.stringify(result);//将对象数组转成字符串传递;
            localStorage.setItem("data", b);//本地储存数据;
            //window.location.href = 'lockdata.html?timestamp=' + +new Date();
        }

lockdatav Done!