[Rd] reading and writing to Google spreadsheets

From: Farrel Buchinsky <fjbuch_at_gmail.com>
Date: Wed, 28 Nov 2007 23:05:30 -0500

Have you ever collaborated? Google Spreadsheets is fantastic to collaborate with. Rather than sending excel spreadsheets backwards and forwards, I would rather use shared Google Spreadsheets. I do not want the intermediate step of exporting a Google Spreadsheet as an xls file. I do not know how to make use of the Google Spreadsheet API (http://code.google.com/apis/spreadsheets/overview.html) but from the little knowledge that I have I can see that this would be the way to enable R to talk to Google. How much work would it be for this to be incorporated into RODBC?

Google Spreadsheets has some phenomenal functionality that uses Google Search engine to populate the columns in a spreadsheet with data. Can you imagine the power of using the Spreadsheet to get the data and R to merge it with ones own research data and then analyze the merged data.

Check this http://googlesystem.blogspot.com/2007/11/connecting-data-using-google.html

Farrel Buchinsky

R-devel_at_r-project.org mailing list
Received on Thu 29 Nov 2007 - 13:56:22 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 29 Nov 2007 - 14:30:36 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.