Make SerializeElement work with range().value output multidimensional array about vba-json-parser HOT 2 CLOSED

@bmclean-nexamp thanks for the input! Support for non 0-based arrays is important. Regarding 2d array - I'm pretty sure that somewhere out of JSON parser scope it's necessary to keep a function, which converts 2d array into nested (jagged) array.

from vba-json-parser.

I think that's a reasonable interpretation as well. In my case, I'm getting a rather large range from the spreadsheet, and I prefer to convert it only once to JSON rather than twice into a jagged array, and then to JSON. There's a noticeable multi-second delay in my use case, which is why I added the support to match what the native function returns.

The way I see it, in the current code if you hand it a one dimensional array, it works. If you hand it a two dimensional array, it errors and does nothing. With the change, if you hand it a two dimensional array, it creates the only JSON equivalent that I can imagine. I'd argue that a generic solution that handled N dimensional arrays would also be legitimate for the JSON code to handle, but that would get expensive and complicated, and the Excel VB api does not return arrays larger than 2 dimensions.

It's really a question of if you see two dimensional arrays as a fundamental VBA data type or not, and I argue that because Excel returns them, they must be.

from vba-json-parser.