How do you reference cells from programming languages?

Technical
1

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.

ref
ref2040×1326 285 KB

2

say i have postgres connection and the table name is tbl_expenses.
how to reference only a subset of the columns ?

df = q.cells(“tbl_expenses[col1,col2]”) ???

3

Great question, looks like we didn’t include this information in our docs. Will add ASAP.

To get a range of columns starting from the first column to the second you’d do:
df = q.cells(“tbl_expenses[[col1:col2]]”)

Let me know if you need any further details.