量角器中的XLSX到JSON转换器。XLSX到JSON的默认转换器不能正常工作

Question

我坚持使用XLSX到JSON的转换器，因为我找不到任何解决方案。我正试图在我的conf.js中将XLSX转换成JSON。这就是我的XLSX的样子。

​

如果我在JSON编辑器中使用XLSX，它就会这样显示我。[{"":"default","Project1":"smoke"},{"":"Specfile1.js","Project1":"Specfile1.js"},{"":"Specfile2.js","Project1":"Specfile2.js"},{"":"Specfile3.js","Project1":"Specfile3.js"},{"":"Specfile4.js","Project1":"Specfile4.js"},{"":"Specfile5.js","Project1":""},{"":"Specfile6.js","Project1":""},{"":"","Project1":"Project2"},{"":"default","Project1":"smoke"},{"":"Specfile1.js","Project1":"Specfile1.js"},{"":"Specfile2.js","Project1":"Specfile2.js"},{"":"Specfile3.js","Project1":"Specfile3.js"},{"":"Specfile4.js","Project1":"Specfile4.js"},{"":"Specfile5.js","Project1":""},{"":"Specfile6.js","Project1":""}]我不确定我应该如何正确地格式化它，比如

{ Project1: {smoke:Specfile1.js,Specfile2.js,Specfile3.js,Specfile4.js, default: Specfile1.js,Specfile2.js,Specfile3.js,Specfile4.js,Specfile5.js,Specfile6.js }, Project2: {smoke: ..., default: ..., sanity: ..... }

Answer 1

我建议将项目拆分为工作表。XLSX按列拆分(第一行是字符串，下一列中的单元格是值)。如果你把它分成几张，你会得到更好的结果。如果您使用逐张元素，您将获得：

 {
  "Project1": [
    {
      "smoke": "Specfile1.js",
      "default": "Specfile1.js"
    },
    {
      "smoke": "Specfile2.js",
      "default": "Specfile2.js"
    },
    {
      "smoke": "Specfile3.js",
      "default": "Specfile3.js"
    },
    {
      "smoke": "Specfile4.js",
      "default": "Specfile4.js"
    }
  ],
  "Project2": [
    {
      "smoke": "Specfile1.js",
      "default": "Specfile1.js"
    },
    {
      "smoke": "Specfile2.js",
      "default": "Specfile2.js"
    },
    {
      "smoke": "Specfile3.js",
      "default": "Specfile3.js"
    },
    {
      "smoke": "Specfile4.js",
      "default": "Specfile4.js"
    }
  ],
  "Sanity": [
    {
      "sanity": "Specfile1.js"
    },
    {
      "sanity": "Specfile2.js"
    }
  ]
}

您可以像这样访问它们：

for(var i = 0; i < Object.keys(test.Project1).length;i++ ) {
     console.log(test.Project1[0].smoke);
}

// Specfile1.js Specfile2.js Specfile3.js Specfile4.js