Forums

My program uses gspread to open and update cells in an existing google docs spreadsheet. It updates every cell correctly until it gets to the last one, then a 409 error is raised.

Traceback (most recent call last): <br /> File "/home/hopkinscj/DRQInput.py", line 548, in <module> <br /> main() <br /> File "/home/hopkinscj/DRQInput.py", line 536, in main <br /> wks.update_cell(rownumber, 8, qdd) <br /> File "/home/hopkinscj/.local/lib/python2.7/site-packages/gspread/models.py", line 408, in update_cell <br /> self.client.put_feed(uri, ElementTree.tostring(feed)) <br /> File "/home/hopkinscj/.local/lib/python2.7/site-packages/gspread/client.py", line 243, in put_feed <br /> raise ex urllib2.HTTPError: HTTP Error 409: Conflict

Please help.

I seem to remember getting something like this when I was messing around with API access to GD spreadsheets. If I remember correctly (that's a big if), it was something to do with miscounting rows and columns so I'd accidentally run off the end of the sheet I'd defined.

I defined a larger sheet than necessary, but it still won't update the cell in question. Although, i don't receive a 409 error anymore.