(Excel) JSON: Miscellaneous Operations

Demonstrates a variety of JSON API methods. This example uses the following JSON document:

{
   "alphabet": "abcdefghijklmnopqrstuvwxyz",
   "sampleData" : {
           "pi": 3.14,
	   "apple": "juicy",
	   "hungry": true,
	   "withoutValue": null,
           "answer": 42
          
	}
}

Download Excel Class Modules Chilkat Excel Class Modules

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

' Assume the file contains the data as shown above..

success = json.LoadFile("qa_data/json/sample2.json")
If (success <> True) Then
    Debug.Print json.LastErrorText
    Exit Sub
End If

' First navigate to the "sampleData" object:

Set sampleData = json.ObjectOf("sampleData")

' Demonstrate BoolAt and BoolOf
Debug.Print "hungry: "; sampleData.BoolOf("hungry")
Debug.Print "hungry: "; sampleData.BoolAt(2)

' StringOf returns the value as a string regardless of it's actual type:
Debug.Print "pi: "; sampleData.StringOf("pi")
Debug.Print "answer: "; sampleData.StringOf("answer")
Debug.Print "withoutValue: "; sampleData.StringOf("withoutValue")
Debug.Print "hungry: "; sampleData.StringOf("hungry")

' Demonstrate IsNullOf / IsNullAt
Debug.Print "withoutValue is null? "; sampleData.IsNullOf("withoutValue")
Debug.Print "withoutValue is null? "; sampleData.IsNullAt(3)
Debug.Print "apple is null? "; sampleData.IsNullOf("apple")
Debug.Print "apple is null? "; sampleData.IsNullAt(1)

' IntOf
Debug.Print "answer: "; sampleData.IntOf("answer")

' SetNullAt, SetNullOf
' Set "pi" to null
success = sampleData.SetNullAt(0)
' Set "answer" to null
success = sampleData.SetNullOf("answer")

' Show the changes:
Debug.Print json.Emit()

' Restore pi and apple:
success = sampleData.SetNumberAt(0,"3.14")
success = sampleData.SetNumberOf("answer","42")

' Show the changes:
Debug.Print json.Emit()

' Add a null value named "afterApple" just after "apple"
success = sampleData.AddNullAt(2,"afterApple")

' Add a boolean value just after "pi"
success = sampleData.AddBoolAt(1,"afterPi",False)

' Examine the changes..
Debug.Print json.Emit()