js处理excle粘贴过来的数据

             var arr1 = [];
            
            var str1 = $("#ts1").value;//excle数据字符串
            var arr2 = {};
            var a = 1;
            for (var q in str1)
            {
                //str2 = str2 + str1[q];
                if (escape(str1[q]) == "%09")
                {
                    arr2[a] = str2;
                    a = a + 1;
                    str2 = "";
                }
                else if (escape(str1[q]) == "%0A")
                {
                    arr2[a] = str2;
                    a = a + 1;
                    arr1.push(arr2);
                    arr2 = {};
                    a = 1;
                }
                else {
                    str2 = str2 + str1[q];
                }
         }

核心就是excle数据在复制后 以 （ escape(str1[q]) = “%09”）为单元格分隔符
以 (escape(str1[q]) == “%0A”) 为换行符。