CRANGETOJSON¶
The CRANGETOJSON formula is used to transform a range of data into a JSON string.
Syntax
CRANGETOJSON (AsObjects, HeaderOrDataRange, DataRange, Chunk)
Arguments¶
AsObjects : boolean (required)¶
Specify whether to return the selected range as an array of objects (true) rather than an array of arrays (false) in the JSON.
HeaderOrDataRange : string (required)¶
Specify the range containing the data to be converted including headers, or if DataRange is specified, the range containing just the headers.
DataRange : string¶
Specify the data range if HeaderOrDataRange only contains headers.
Chunk : number¶
Specify which chunk to output for cases where the total size of the JSON is larger than a cell’s maximum size (32,000 characters).
Default value: 1