Copyright (C) 2020 by donggeuri0320 [email protected]

Excel2json is a converting script that supports to manage well structured excel data to json format.

You can freely redistribute this product with A-CUP-OF-BEER License (See source code)

It's similar to https://github.com/coolengineer/excel2json

n: number
narr: number array
s: string
sarr: string array

Please refer to ./xlsx/test.xlsx

{
	"initdata":{
		"a": "apple",
		"b": "banana"
	}
}

An integer can be specified as a range value.

{
  "girlgroup":{
		"blackpink":{"peopleCnt":5, "peopleIds":[1,2,3,12]},
		"twice":{"peopleCnt":9, "peopleIds":[5,6,7,8,9,10,11,13]},
		"hmm..":{"peopleCnt":0, "peopleIds":[]}
	}
}

{
  "people":[
      {"peopleId":1, "name":"jisso", "test":["a","b","c"]},
      {"peopleId":2, "name":"jennie", "test":["a"]},
      {"peopleId":3, "name":"rose", "test":[]},
      {"peopleId":4, "name":"나연", "test":["b"]},
      {"peopleId":5, "name":"정연", "test":["c"]},
      {"peopleId":6, "name":"모모", "test":["d","e"]},
      {"peopleId":7, "name":"사나", "test":[]},
      {"peopleId":8, "name":"지효", "test":[]},
      {"peopleId":9, "name":"미나", "test":[]},
      {"peopleId":10, "name":"다현", "test":["f"]},
      {"peopleId":11, "name":"채영", "test":[]},
      {"peopleId":12, "name":"lisa", "test":[]},
      {"peopleId":13, "name":"쯔위", "test":[]}
    ]
}