15 August 2018

JS解析excel中的手机号码

添加依赖

js-xlsx
下载dist目录下的xlsx.full.min.js文件

代码

<html>

<head>
    <script src="./xlsx.full.min.js"></script>
</head>

<body>
    <input id="file" type="file" />
    <script>
        var phoneReg = /(^1[3|4|5|7|8]\d{9}$)|(^09\d{8}$)/;
        var rABS = typeof FileReader !== 'undefined' && FileReader.prototype && FileReader.prototype.readAsBinaryString;
        var file = document.getElementById("file");
        function to_json(workbook) {
            if (workbook.SSF) XLSX.SSF.load_table(workbook.SSF);
            var result = {};
            workbook.SheetNames.forEach(function (sheetName) {
                var roa = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], { header: 1 });
                if (roa.length > 0) result[sheetName] = roa;
            });
            return result;
        }
        function filechange(e) {
            var file = e.target.files[0];
            var reader = new FileReader();
            reader.onload = function (le) {
                var data = le.target.result;
                var wb, arr;
                wb = XLSX.read(data, { type: 'binary' });
                var sheet = wb.SheetNames[0];
                var json = to_json(wb)[sheet];
                var phones = [];
                for(var i of json) {
                    for(var j of i){
                        if (j && phoneReg.test(j)) {
                            phones.push(j);
                        }
                    }
                }
                console.log(phones);
            }
            reader.readAsBinaryString(file);
        }
        file.addEventListener("change", filechange, false);
    </script>
</body>

</html>