JSONGenerator

JSON generator from Excel files with template.

- Dependencies

openpyxl

- Usage

Using template to build up the links between Excel and JSON entries

Excel column names → JSON match template → JSON path

- Format

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.