VBA macro needed to save a series Excel sheets to json
Budget: £20 – £250 GBP
I need to convert the values from the Excel sheets (Green worksheets) to a single json file, this is a set of nested links.
In the example, for each ScreenReference (for each unique screen name), I need to create a nested set of links for that screen, the values in the column LinksLevel should determine the nesting level of the links (but should not be included in the json output). The columns in the Config worksheet are to be used to construct the Section, Title and Root-Url values
The final output should be a single json file that contains the reference to the schema, the documentations section, and then the sections as per the example. The macro should output the file to a destination (to be user set).
The workbook provided has the json libraries installed, but the help required is to sort out the looping, for the links levels.
In the example, for each ScreenReference (for each unique screen name), I need to create a nested set of links for that screen, the values in the column LinksLevel should determine the nesting level of the links (but should not be included in the json output). The columns in the Config worksheet are to be used to construct the Section, Title and Root-Url values
The final output should be a single json file that contains the reference to the schema, the documentations section, and then the sections as per the example. The macro should output the file to a destination (to be user set).
The workbook provided has the json libraries installed, but the help required is to sort out the looping, for the links levels.