put a data.frame into a Google spreadsheet

[jennybc]

Was reading the wee bit there is about Pandas and gspread …

burnash/gspread#138

https://github.com/burnash/gspread/wiki/Cookbook

Brings up the interesting issue of … going from an R data.frame TO a Google spreadsheet. Not writing to just one cell but a bulk write.

[leeper]

Perhaps the best way to handle that is saving the dataframe to a file and then uploading using the Drive API (specifically the file insert endpoint, using the convert = true argument).

If the Drive API had its own package, it would be easy to then import the upload/insert function from there.

[jennybc]

Was reminded of this while reviewing the PR to restore ability to create a new (empty) spreadsheet (#29). I'm not sure if there's much use for creating an empty spreadsheet? But perhaps there is. I think more common use case would be creating a new spreadsheet AND populating it with data.

Just adding some links for when/if we pursue. Agree with @leeper's assessment of the situation.

http://stackoverflow.com/questions/12765813/upload-csv-to-google-drive-spreadsheet-using-drive-v2-api

https://developers.google.com/drive/v2/reference/files/insert

[jennybc]

In 9ead0d2 we (re)gained the ability to upload a data.frame into cells in a sheet.

Making a new issue for "upload csv".