3

I'm using gspread to modify a Google Sheets, but I keep getting this error when I run it:

AttributeError: 'Worksheet' object has no attribute 'get_addr_int'

Here is my code:

import json
import gspread
from oauth2client.client import SignedJwtAssertionCredentials

json_key = ###
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope)

gc = gspread.authorize(credentials)

sheet = gc.open("worksheet")

sh = sheet.sheet1
dates_array = sh.row_values(2)
col = len(dates_array) 
signin_array = sheet.worksheets()[1:]
id_array = sh.col_values(3)[2:]
 if signin.title in dates_array:
  continue 
 col += 1
 sh.update_cell(2, col, signin.title)
 cell = sh.get_addr_int(2, col)

I have also tried using "rowcol_to_a1" and "utils.rowcol_to_a1" and got the same error.

0 Answers0