How to get address from Google Sheets if I had position of row and column?-CodePudding

.Hello, everyone. I need some help.

I'm trying to put data into my Google Sheet via this:

sheet.values().update(spreadsheetId=SPREADSHEET_ID, range="Everyday!B131", valueInputOption="USER_ENTERED", body={"values":time_value}).execute()

But instead the cell with address B131, I need to put data another cell with unknown address. But I know what is the row and column. How can I get the address in this situation?

CodePudding user response：

If you know the column and row, then you should be able to concatenate them into the address:

column = '131'
row = 'B'
sheet = 'Everyday'

address = sheet   '!'   row   column
print(address)

output: Everyday!B131