getRangeValue

returns values from the range

array getRangeValue(string range, [string page] );
rangestringthe range of cells (or multiple ranges)
pagestringoptional, the name of the sheet you want to perform an operation on
arrayan array of values from the range (or an array of arrays)

Example

// returns a value for a single range
const value = $$("ssheet").getRangeValue("A1:B2","Sheet2"); 
// -> [188400,52000,240400]
 
// returns a value for multiple ranges
const value2 = $$("ssheet").getRangeValue("C3:E3;C5:E5","Sheet2"); 
// -> [[188400,52000,240400],[68900,8000,76900]]

Details

The range parameter accepts multiple ranges with a semicolon as delimiter: "A1:C3;B4:D5".

See also
Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.