How to convert excel file into json file using vbscript

Question

I want to convert my excel file has dictionary data into a json file to use it with java script

Answer 1

- you can save it in Csv and then parse the array into a Json array in a script (for example, here https://www.csvjson.com/csv2json)
- You can use the ActiveX module and save the page data in XML, and overtake XML in JSOn.
(https://www.freeformatter.com/xml-to-json-converter.html)
- it is commonplace to collect a Json string from the page data, if you use the VBScript language built into Excel.
https://youtu.be/YgwUS9vvTTU