returns values from the range
| range | string | the range of cells (or multiple ranges) |
| page | string | optional, 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) |
// 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]]
The range parameter accepts multiple ranges with a semicolon as delimiter: "A1:C3;B4:D5".