js 本地读取excel 转json

最新推荐文章于 2024-03-20 16:20:49 发布

Perferson

最新推荐文章于 2024-03-20 16:20:49 发布

阅读量811

点赞数

文章标签： javascript json 前端

本文链接：https://blog.csdn.net/nongmai6494/article/details/126391831

版权

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <title></title>
  </head>
  <body>
    <div class="nav">
      <!-- webkitdirectory directory multiple -->
      <input type="file" id="excel" />
    </div>
    <div id="content" style="width: 1000px; height: 500px"></div>
    <script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>
    <script
      type="text/javascript"
      src="https://cdn.staticfile.org/xlsx/0.15.1/xlsx.core.min.js"
    ></script>
    <script>
      $("#excel").change(function (e) {
        var files = e.target.files //获取文件
        read(files)
      })
      //传入一个文件
      function read(files) {
        // 以二进制方式打开文件
        if (files.length == 0) {
          return
        }
        for (let i = 0; i < files.length; i++) {
          var fileReader = new FileReader()
          fileReader.readAsBinaryString(files[i])
          fileReader.onload = function (ev) {
            try {
              var data = ev.target.result
              var workbook = XLSX.read(data, {
                type: "binary",
              }) // 以二进制流方式读取得到整份excel表格对象
              persons = []
            } catch (e) {
              return
            }
            // 表格的表格范围，可用于判断表头是否数量是否正确
            var fromTo = ""
            // 遍历每张表读取
            for (var sheet in workbook.Sheets) {
              if (workbook.Sheets.hasOwnProperty(sheet)) {
                fromTo = workbook.Sheets[sheet]["!ref"]
                if (!fromTo) {
                  return
                }
                persons = XLSX.utils.sheet_to_json(workbook.Sheets[sheet])
                console.log(persons)
                var arr = new Array()
                arr.push(persons)
                document.getElementById("content").innerHTML =
                  formatJson(persons)
                //document.getElementById("content").innerHTML = JSON.stringify(arr);
              }
            }
          }
        }
      }
      function formatJson(msg) {
        var rep = "~"
        var jsonStr = JSON.stringify(msg, null, rep)
        var str = ""
        for (var i = 0; i < jsonStr.length; i++) {
          var text = jsonStr.charAt(i)
          if (i > 1) {
            var text = jsonStr.charAt(i - 1)
            if (rep != text && rep == text2) {
              str += "<br/>"
            }
          }
          str += text
        }
        jsonStr = ""
        for (var i = 0; i < str.length; i++) {
          var text2 = str.charAt(i)
          if (rep == text2)
            jsonStr += "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
          else {
            jsonStr += text2
          }
          if (i == str.length - 2) jsonStr += "<br/>"
        }
        return jsonStr
      }
    </script>
  </body>
</html>