getRangeValue

returns values from the range

array getRangeValue(string range, [string page] );

range

stringthe range of cells (or multiple ranges) page

stringoptional, the name of the sheet you want to perform an operation on

array

an 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".