(Excel) Load a JsonArray

Demonstrates how to load a JsonArray.

Note: This example requires Chilkat v9.5.0.64 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires Chilkat v9.5.0.64 or greater.

' Loading into a new JSON array is simple and straightforward.
Dim a As Chilkat.JsonArray
Set a = Chilkat.NewJsonArray
Dim success As Boolean
success = a.Load("[ 1,2,3,4 ]")

' Output:  [1,2,3,4]
Debug.Print a.Emit()
Debug.Print "--------"

' The JsonArray's Load and LoadSb methods have a peculiar behavior when
' it is already part of a JSON document.  In this case, the JsonArray
' becomes detached, and the original document remains unchanged.
' This is intentional due to the nature of the internal implementation.
' For example:

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load("{ ""abc"": [ 1,2,3,4 ] }")

' Output:  (json) {"abc":[1,2,3,4]}
Debug.Print "(json) "; json.Emit()
Debug.Print "--------"


Set abc = json.ArrayOf("abc")
' When Load is called, abc becomes it's own document, and the original is not modified.
success = abc.Load("[ 5,6,7,8 ]")

' Output: (abc) [5,6,7,8]
Debug.Print "(abc) "; abc.Emit()
Debug.Print "--------"

' Output: (json) {"abc":[1,2,3,4]}
Debug.Print "(json) "; json.Emit()
Debug.Print "--------"