search

mhaemmerle / excel-to-json

Opinionated Excel to JSON converter where nested structures can be defined on different worksheets
http://mhaemmerle.github.io/excel-to-json/
Apache License 2.0
102 stars 25 forks source link

Empty objects and keys are generated #6

Closed eproxus closed 10 years ago

eproxus commented 10 years ago

The following file:

Sheet 1: test.json

id
foo

Sheet 2: test.json#properties

id traits a b
foo 1 1 9

Generates the following JSON:

[
  {
    "traits": {
      "a": {
        "a": 1,
        "b": 9,
        "": ""
      }
    },
    "id": "foo",
    "": ""
  },
  {
    "traits": {
      "": {
        "a": "",
        "b": "",
        "": ""
      }
    },
    "id": "",
    "": ""
  }
]

Basically, the last object is an empty object with no data and both objects contain empty key/value pairs.