Excel-jSon-Excel in one line of code
On the ramblings site, I set myself the challenge to write some classes that could be invoked to convert an entire Worksheet to jSon, or alternatively, to consume a webservice and populate and entire worksheet in one line of code.
These examples, and the classes they use can be downloaded from the ramblings site, and are in included in cDataSet.xlsm.
create and print a jSon string from a worksheet.
The jSon string both created and consumed looks like this – or see it online