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

1. string: example
2. int & float: 15, 1.0
3. range: [-1,100]
4. list: [here, is, example], ["here", "is", "example"]
5. dict: NO dictionary as entries, instead using column names to locate the position directly.