(Excel) Create a JSON Array of Objects

Demonstrates how to create a JSON array of objects.

Download Excel Class Modules Chilkat Excel Class Modules

Dim arr As Chilkat.JsonArray
Set arr = Chilkat.NewJsonArray

' Add an empty object at the 1st JSON array position.
Dim success As Boolean
success = arr.AddObjectAt(0)
' Get the object we just created.

Set obj = arr.ObjectAt(0)
success = obj.UpdateString("Name","Otto")
success = obj.UpdateInt("Age",29)
success = obj.UpdateBool("Married",False)

' Add an empty object at the 2nd JSON array position.
success = arr.AddObjectAt(1)
Set obj = arr.ObjectAt(1)
success = obj.UpdateString("Name","Connor")
success = obj.UpdateInt("Age",43)
success = obj.UpdateBool("Married",True)

' Add an empty object at the 3rd JSON array position.
success = arr.AddObjectAt(2)
Set obj = arr.ObjectAt(2)
success = obj.UpdateString("Name","Ramona")
success = obj.UpdateInt("Age",34)
success = obj.UpdateBool("Married",True)

' Examine what we have:
arr.EmitCompact = False
Debug.Print arr.Emit()

' The output is:

' [
'   {
'     "Name": "Otto",
'     "Age": 29,
'     "Married": false
'   },
'   {
'     "Name": "Connor",
'     "Age": 43,
'     "Married": true
'   },
'   {
'     "Name": "Ramona",
'     "Age": 34,
'     "Married": true
'   }
' ]