1

This question is covered for google scripts, however I would like to know how to do it using google API (specifically python).

Given a certain column/cell in a google sheet, is there a way to go to cell say, 5 columns to the right, or the 3 rows down? I couldn't find anything like that in the Google Sheets api v4

Community
  • 1
  • 1
abbood
  • 23,101
  • 16
  • 132
  • 246

2 Answers2

0

Sheets API doesn't have such functionality. Try to file a request here. Sheets API uses the A1 Notation. You can see the read cell methods in Basic Reading guide.

ReyAnthonyRenacia
  • 17,219
  • 5
  • 37
  • 56
0

I initially tried to do it via Google API directly, and just like you, I wasn't able to find relevant documentation. I eventually decided to use this wrapper https://github.com/burnash/gspread which allows for this functionality easily:

 cell1 = mySheet.sheet.acell('c6')
 cell2 = mySheet.sheet.cell(cell1.row + 5, cell1.col+3)
Alexei Masterov
  • 382
  • 2
  • 10