Skip to main content

RANGE

Creates a nested JSON array from specified cell range. Basically this is the same as using array with nested and flat parameter set to true.

Syntax

=RANGE(Cellrange)

Arguments

NameDescription
CellrangeSource Range to retrieve data from.

Return Value

A nested list of cell values.

Example

FunctionResultComment
=RANGE(A1:A1)[[42]]Range defines only one cell, so returned list contains one list with one value.
=RANGE(A1:C1)[[42, 23, 13]]Range defines 3 values over 1 row, so returned list contains a list with 3 values.
=RANGE(A1:B2)[[42, 23], [13, 17]]Range defines 4 values over 2 rows, so returned list contains 2 lists with 2 values each.