0

I want to convert excel to json like below.I want to use js-xlsx,but i don't know how to implement it

{"OrderNo":"120555",
"Order Date":"20160218",
"Courier Bill NO":"120555",
"orderShipperName":"INLAY SHOES ",
"ConsigneeName":"LEE",
"part":[{"description":"USB","qty":"2","units":"PCM"},
      {"description":"IPONE","qty":"3","units":"PCM"}]}

enter image description here

xiami0980
  • 1
  • 1
  • Looks like valid json to me – Peter Chaula Aug 15 '16 at 07:21
  • No, it is not. Just copy/paste to jsonformatter and you will see that "part" needs double quotes, one "]" is leaking... – Lino Aug 15 '16 at 07:26
  • { "OrderNo": "120555", "Order Date": "20160218", "Courier Bill NO": "120555", " orderShipperName": "INLAY SHOES ", "ConsigneeName": "LEE", "part": [ { "description": "USB", "qty": "2", "units": "PCM" }, { "description": "IPONE", "qty": "3", "units": "PCM" } ] } – xiami0980 Aug 15 '16 at 07:34
  • `jq` parses this as JSON. Where do you have a problem with it? – nwk Aug 15 '16 at 07:36
  • I don't know how to get . – xiami0980 Aug 15 '16 at 07:38

0 Answers0