JSON generator from Excel files with template.
- openpyxl
using template to build up the links between Excel and JSON entries
- Excel column names → match template → JSON path
formats of the entries in Excel dataset
- string:
example
- int & float:
15
,1.0
- range:
[-1,100]
- list:
[here, is, example]
,["here", "is", "example"]
- dict: - NO dictionary as entries, instead using column names to locate the position directly.