js实现json文件转Excel

末蓝、 2023-10-05 14:27 16阅读 0赞

<!doctype html>
    <html lang="en">
    <head>
      <meta charset="UTF-8">
      <meta name="viewport"
            content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
      <meta http-equiv="X-UA-Compatible" content="ie=edge">
      <script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
      <title>Document</title>
    </head>
    <body>
    <div>
      <input type="file" id="files"/>
      <button onclick="jsonToExcel()">导出为Excel</button>
    </div>
    <script>
      var json;
      var inputElement = document.getElementById("files");
      inputElement.addEventListener("change", handleFiles, false);
      function handleFiles() {
        var selectedFile = document.getElementById("files").files[0];
        var reader = new FileReader();
        reader.readAsText(selectedFile,"UTF-8");
        reader.onload = function(){
          json = JSON.parse(this.result);
        };
      }
      function jsonToExcel () {
        var filename = "write.xlsx";
        var ws_name = "SheetJS";
        var wb = XLSX.utils.book_new();
        var ws = XLSX.utils.json_to_sheet(json);
        XLSX.utils.book_append_sheet(wb, ws, ws_name);
        XLSX.writeFile(wb, filename);
      }
    </script>
    </body>
    </html>

需要引用[xlsx.full.min.js][] ，提取码: pfax

测试json格式：\[\{"id":"111","Name":"张三","sort":1\},\{"id":"222","Name":"李四","sort":2\},\{"id":"333","Name":"王五","sort":3\}\]

无效json格式：\{"result":\[\{"id":"111","Name":"张三","sort":1\},\{"id":"222","Name":"李四","sort":2\},\{"id":"333","Name":"王五","sort":3\}\]\}

参考文章：[https://blog.csdn.net/yang939207690/article/details/108221933][https_blog.csdn.net_yang939207690_article_details_108221933]

[xlsx.full.min.js]: https://pan.baidu.com/s/15cfdPXfHu6ntwFVtpI7Vsg
[https_blog.csdn.net_yang939207690_article_details_108221933]: https://blog.csdn.net/yang939207690/article/details/108221933