getSheetData

allows accessing data and ranges of any sheet

void getSheetData(string sheet_name);

Deprecated

This property is deprecated. Please, use getCellValue, setCellValue, getRangeValue and setRangeValue to access the data of sheet cells.

sheet_name

string

the 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")