{"action":"created","issue":{"url":"https://api.github.com/repos/burnash/gspread/issues/51","repository_url":"https://api.github.com/repos/burnash/gspread","labels_url":"https://api.github.com/repos/burnash/gspread/issues/51/labels{/name}","comments_url":"https://api.github.com/repos/burnash/gspread/issues/51/comments","events_url":"https://api.github.com/repos/burnash/gspread/issues/51/events","html_url":"https://github.com/burnash/gspread/issues/51","id":14699915,"number":51,"title":"Quickest update methods","user":{"login":"TravisJoe","id":2984346,"avatar_url":"https://avatars1.githubusercontent.com/u/2984346?v=4","gravatar_id":"","url":"https://api.github.com/users/TravisJoe","html_url":"https://github.com/TravisJoe","followers_url":"https://api.github.com/users/TravisJoe/followers","following_url":"https://api.github.com/users/TravisJoe/following{/other_user}","gists_url":"https://api.github.com/users/TravisJoe/gists{/gist_id}","starred_url":"https://api.github.com/users/TravisJoe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TravisJoe/subscriptions","organizations_url":"https://api.github.com/users/TravisJoe/orgs","repos_url":"https://api.github.com/users/TravisJoe/repos","events_url":"https://api.github.com/users/TravisJoe/events{/privacy}","received_events_url":"https://api.github.com/users/TravisJoe/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2013-05-23T22:57:10Z","updated_at":"2018-04-27T13:41:32Z","closed_at":"2013-11-17T14:40:24Z","author_association":"NONE","body":"I am using this API in a chunk of software for automated testing and uploading resulting data to a spreadsheet to share.\n\nI am noticing some lag on uploads and I can easily work around it, but I want to make sure I am not doing it wrong or there is a much quicker way. Essentially I am updating a cell at a time. The row can change often so I figured it would be easier to go by row number over cell name like \"A1\".\n\n``` python\nworkSheet.update_cell(conInfo[0],1,time.strftime(\"%Y-%m-%d %H:%M:%S\", conInfo[1]))\nworkSheet.update_cell(conInfo[0],2,conInfo[2])\nworkSheet.update_cell(conInfo[0],3,conInfo[3])\nworkSheet.update_cell(conInfo[0],4,conInfo[4])\n```\n"},"comment":{"url":"https://api.github.com/repos/burnash/gspread/issues/comments/384973338","html_url":"https://github.com/burnash/gspread/issues/51#issuecomment-384973338","issue_url":"https://api.github.com/repos/burnash/gspread/issues/51","id":384973338,"user":{"login":"RichardJamesLopez","id":8483531,"avatar_url":"https://avatars2.githubusercontent.com/u/8483531?v=4","gravatar_id":"","url":"https://api.github.com/users/RichardJamesLopez","html_url":"https://github.com/RichardJamesLopez","followers_url":"https://api.github.com/users/RichardJamesLopez/followers","following_url":"https://api.github.com/users/RichardJamesLopez/following{/other_user}","gists_url":"https://api.github.com/users/RichardJamesLopez/gists{/gist_id}","starred_url":"https://api.github.com/users/RichardJamesLopez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RichardJamesLopez/subscriptions","organizations_url":"https://api.github.com/users/RichardJamesLopez/orgs","repos_url":"https://api.github.com/users/RichardJamesLopez/repos","events_url":"https://api.github.com/users/RichardJamesLopez/events{/privacy}","received_events_url":"https://api.github.com/users/RichardJamesLopez/received_events","type":"User","site_admin":false},"created_at":"2018-04-27T13:41:32Z","updated_at":"2018-04-27T13:41:32Z","author_association":"NONE","body":"Along the same lines, is there a way to update cells from a dataframe. Right now, I am appending rows to a spreadsheet?\r\n\r\nHowever, my objective is to run this script and be able to overwrite the old values with new values from a df titled \"coinArray\". Right now, I have \r\n\r\n`\r\nbook = gc.open('<spreadsheetname>')\r\nsheet = book.worksheet('<worksheetname>')\r\n\r\nfor row in coinArray.iterrows():\r\n    sheet.append_row(row[1].tolist())\r\n`\r\n\r\nBy appending the rows, I am just adding to a list and not replacing existing values. "}}
{"actor":{"display_login":"RichardJamesLopez"}}