excel转json

最新推荐文章于 2025-04-17 19:30:00 发布

Zhu Xiaopi

最新推荐文章于 2025-04-17 19:30:00 发布

阅读量363

点赞数

文章标签： excel json

本文链接：https://blog.youkuaiyun.com/qq_46063425/article/details/130206417

版权

html

<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8" />
    <title>Excel to JSON Converter</title>
    <script src="./xlsx.full.min.js"></script>
  </head>
  <body>
    <input type="file" onchange="handleFileSelect(event)">
    <pre id="output"></pre>

    <script src="app.js"></script>
  </body>
</html>

function handleFileSelect(event) {
    const file = event.target.files[0];
    const reader = new FileReader();
    reader.onload = function() {
      const data = reader.result;
      const workbook = XLSX.read(data, { type: 'binary' });
      const sheet_name_list = workbook.SheetNames;
      const json_data = sheet_name_list.map(function(sheet_name) {
        const worksheet = workbook.Sheets[sheet_name];
        const headers = {};
        let valueJson = {};
        for (let cell in worksheet) {
          if (cell[0] === '!'||cell[0]==="A"||cell[1]==="1") continue;
          console.log("cell[0]",cell[0],cell[1])
          valueJson = headers[worksheet[cell[0]+"1"].v] || {}
          valueJson[worksheet["A"+cell[1]].v] = worksheet[cell].v;
          headers[worksheet[cell[0]+"1"].v]=valueJson;
        }
        return headers;
      });
      document.getElementById('output').innerHTML = JSON.stringify(json_data);
    };
    reader.readAsBinaryString(file);
  }