getSheetData

allows accessing data and ranges of any sheet

void getSheetData(string sheet_name);

Parameters

sheet_namestringthe name of the sheet

Example

// getting a cell value
$$("ssheet").getSheetData(sheet_name).getValue(1,1)
 
// getting a range of cells
$$("ssheet").getSheetData(sheet_name).getRangeValue("A1:B8")
 
// getting a named range
$$("ssheet").getSheetData(sheet_name).getRangeValue("AFTERDATA")

See also
Back to top