Python
Single cell: c(x,y)
1-D: cells((x1, y1), (x2, y2), first_row_header=True)
2-D: cells((x1, y1), (x2, y2), first_row_header=True)
Reference another sheet: cells((x1, y1), (x2, y2), 'Other_sheet_name')
Single cell references are placed in variable of appropriate type. Multiple-cell references are placed in DataFrames. To make the first column the DataFrame header, set first_row_header=True in your references.
JavaScript
Single cell: cell(x1,y1)
Multiple cells: cells(x1, y1, x2, y2)
To reference cells faster use the cell reference button in the code editors.
