Search code examples
pythongoogle-apps-scriptgspreadnamed

is it possible to use named functions with gspread?

I want to use a function on a cell with gspread, how does it work?

tried this:

cell_b2 = worksheet.COUNT(D3,E7).value

the function I want to execute using gspread

does not work

Solution

  • Hi unfortunately it does not work this way.

    In order to use a spreadsheet function (like COUNT or IF etc) you must update the cell where you want that function using methods like: update_acell that will update a single celle with the new content.

    Example:

    worksheet.update_acell("A1", "=COUNT(D3,E7)")

    then the result can be seen in the spreadsheet in the worksheet at the cell A1.