Converting Excel data to JSON is a bit complex process depending on the
structure of data it varies and auto creation may not be possible.
VBA coding is verymuch essential.
Here is one resource you can try for tools to convert excel data to json
format, code is not provided but they promise
Try this code
http://www.excelvbamacros.in/2015/01/export-range-in-jason-format.html
On Monday, 5 August 2013 21:31:10 UTC+5:30, Godiva Man wrote:
>
> Hi experts,
>
> Does anyone have a VBA script to convert excel files that can define a
> structure to be exported into a json format
>
>
>
--
