Skip to content

CRANGETOJSON

The CRANGETOJSON formula is used to transform a range into a JSON string.

Syntax

CRANGETOJSON (AsObjects, HeaderOrDataRange, DataRangeChunk)

Arguments

AsObjects

(Required)

Return the selected range as an array of objects rather than an array of arrays in the JSON

HeaderOrDataRange

A range containing the data to be converted including headers, or if DataRange is specified, just the headers

DataRange

Optional data range if HeaderRange is specified

Chunk

Specify the chunk this will output for where the total size of the JSON is larger than a cells max size (32,000 characters)

Default value: 1