VBA macros for exporting an excel sheet to Json format
Simple macros that will export a excel sheet like this:
to a json file called sheet_name.json with this structure:
By default, the file will be created in C:\Users\Usuario\Desktop. To change this, it has to be done inside the macros code:
- In order to work, it is required to:
- Have a first row with the column names
- Have a second row with the data types:
- 'str' for strings
- 'num' for ints, floats and booleans
- 'arr_str' for arrays of strings
- 'arr_num' for arrays of ints, floats and booleans
- Have the array data values separated by coma and without spaces (unless your strings intentionally have spaces)
By default, the macros is run using ctrl + E