{"action":"created","issue":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/127","repository_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet","labels_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/127/labels{/name}","comments_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/127/comments","events_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/127/events","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/127","id":163520316,"number":127,"title":"Prepend a row to top spreadsheet","user":{"login":"Connor-Knabe","id":4316793,"avatar_url":"https://avatars.githubusercontent.com/u/4316793?v=3","gravatar_id":"","url":"https://api.github.com/users/Connor-Knabe","html_url":"https://github.com/Connor-Knabe","followers_url":"https://api.github.com/users/Connor-Knabe/followers","following_url":"https://api.github.com/users/Connor-Knabe/following{/other_user}","gists_url":"https://api.github.com/users/Connor-Knabe/gists{/gist_id}","starred_url":"https://api.github.com/users/Connor-Knabe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Connor-Knabe/subscriptions","organizations_url":"https://api.github.com/users/Connor-Knabe/orgs","repos_url":"https://api.github.com/users/Connor-Knabe/repos","events_url":"https://api.github.com/users/Connor-Knabe/events{/privacy}","received_events_url":"https://api.github.com/users/Connor-Knabe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-02T14:17:46Z","updated_at":"2016-08-16T19:01:07Z","closed_at":null,"body":"First off thank you so much for making this wonderful module! \r\n\r\nCurrently .addRow() appends the row to the first empty space in the sheet.  I was wondering if there is a way to have it prepend the first empty row? So if I have a blank space at the top of my sheet it would fill data there and then the next row it adds would be above that.  I've played with inserting empty rows but the API doesn't seem to recognize rows inserted by itself as empty.  Now if I go to my sheet and manually hit delete on a row then the API will insert it above that cleared out row.\r\n\r\nAny ideas? \r\nI looked into issue #49 but that seemed quite a bit more complicated than this."},"comment":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/comments/240203737","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/127#issuecomment-240203737","issue_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/127","id":240203737,"user":{"login":"theoephraim","id":1158956,"avatar_url":"https://avatars.githubusercontent.com/u/1158956?v=3","gravatar_id":"","url":"https://api.github.com/users/theoephraim","html_url":"https://github.com/theoephraim","followers_url":"https://api.github.com/users/theoephraim/followers","following_url":"https://api.github.com/users/theoephraim/following{/other_user}","gists_url":"https://api.github.com/users/theoephraim/gists{/gist_id}","starred_url":"https://api.github.com/users/theoephraim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theoephraim/subscriptions","organizations_url":"https://api.github.com/users/theoephraim/orgs","repos_url":"https://api.github.com/users/theoephraim/repos","events_url":"https://api.github.com/users/theoephraim/events{/privacy}","received_events_url":"https://api.github.com/users/theoephraim/received_events","type":"User","site_admin":false},"created_at":"2016-08-16T19:01:07Z","updated_at":"2016-08-16T19:01:07Z","body":"AFAIK, the api for adding rows only lets you append to the bottom. And I don't think there are any other API methods for inserting empty rows. So you would have to actually use the bulk cell update methods to move all the content down a row, and then fill in the first row.\r\n\r\nNot really worth it IMO.\r\n\r\nHowever, it could be that there are new methods in the v4 of the API! I haven't looked yet."}}
{"actor":{"display_login":"theoephraim"}}