This is by far the most popular topic on this site. If you want to ask some questions, have difficulty with the downloads, or if this is not what you expected to find here, please leave a comment or ask a question on our Forum gadget to help improve the usefulness of the material.
If you are interested in excel to json or json to excel conversion then this is the right place. It's also the right place if you are wondering how to represent objects which are more than two dimensions in VBA, whether or not json conversion is involved.
Here's a quick primer on how JSON is handled once parsed from a JSON string.
Normally visitors to this page
have a specific jSon conversion problem. The following bullets should
help guide you to to a solution.
In all cases, I use a custom class cJobject to both serialize and deserialize jSon. Although its purpose is about this kind of conversion, it is a useful object that can be used for all kinds of heirarchical storage. See Rest Results Explorer for visualizing a cJobject. The Data Manipulation Classes used to abstract Excel data have a .Jobject property. This means that entire excel tables can be converted to cJobject and then serialized in one line of code.
Here is a very simple example using the cJobect. You will need to start with a workbook containing the required classes, cDataSet.xlsm which you can download from Download Complete Projects
Serializing the object gives us a nice jSon string that we can exchange with webservices or another language.
A very simple example - creating jSon representation of an Excel Sheet and cloning the whole sheet to another sheet. Normally you would jSon to exchange data with webservices, but it's this simple to use the cJobject inside Excel also.
Want Something simpler? Take a look at Excel JSON conversion for 1 line of code to populate an Excel sheet from a webservice, and 1 line to convert an entire worksheet to jSon.
All the examples contain all the classes needed for them to work and all projects can be found here.
If you just want the main utility classes used throughout this site, in the Downloads section cDataSet.xlsm includes everything you need including some examples.
Here are a selection of examples of projects on this site that convert to and from jSon.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation >