(Solved) – Excel to json file from Excel VBA

(solved)-–-excel-to-json-file-from-excel-vba

I want to have a button in an excel document (using VBA) which, takes in the data on the sheet and outputs a file (.json). Which I can then use later on within a web page.

I my excel data looks like this:

Image of excel table

Note I would like to have more than one instance of data.
I want it to generate a json file in the format of:

{
	"Excel_test": [
		{
			"name" : "tesintg1",
			"age" : 15
		},
		{
			"name" : "testng2",
			"age" : 1
		},
		{
			"name" : "testing3",
			"age" : 435
		}
	]
}
Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *