Skip to main content
Version: Streamsheets 2.5

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

A nested list of cell values.

Examples

FormulaResultComment
=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.