js 上传excel解析成json，并保存为json文件（可下载）-CSDN博客

本文链接：https://blog.csdn.net/TheWise_lzy/article/details/108303056

引用：

    <script src="https://cdn.staticfile.org/echarts/4.3.0/echarts.min.js"></script>
    <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.js"></script>
    <script src="https://unpkg.com/xlsx@0.13.3/dist/xlsx.full.min.js"></script>
    <script src="https://cdn.bootcss.com/FileSaver.js/2014-11-29/FileSaver.js"></script>

js：

<body>
<input type="file" id="fileUploader" name="fileUploader" accept=".xls, .xlsx"/>
<input type="button" id="export" value="保存"/>
</br></br>
<script>
    var content;
    var button = document.getElementById("export");
    button.addEventListener("click", saveHandler, false);
    function saveHandler() {
        var blob = new Blob([content], {type: "text/plain;charset=utf-8"});
        saveAs(blob, "save.json");
    }
    $(document).ready(function(){
        $("#fileUploader").change(function(evt){
            var selectedFile = evt.target.files[0];
            var reader = new FileReader();
            reader.onload = function(event) {
                var data = event.target.result;
                var workbook = XLSX.read(data, {
                    type: 'binary'
                });
                workbook.SheetNames.forEach(function(sheetName) {
                    var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
                    if (XL_row_object.length > 0) {
                        content = JSON.stringify(XL_row_object);
                        console.log(content);
                        //document.getElementById("jsonObject").innerHTML = JSON.stringify(XL_row_object);
                    }

                })
            };
            reader.onerror = function(event) {
                console.error("File could not be read! Code " + event.target.error.code);
            };
            // 读取上传文件为二进制
            reader.readAsBinaryString(selectedFile);
        });
    });

</script>
</body>