Skip to content

Reading .gsheet within R

5 messages · Luca Meyer, Rui Barradas, Marc Schwartz +2 more

#
Hello,

Package sos does a good job at finding things available for R.

library(sos)
findFn('gsheet')
found 0 matches
x has zero rows;  nothing to display.
Warning message:
In findFn("gsheet") : HIT not found in HTML;  processing one page only.


So I guess there's nothing yet.

Hope this helps,

Rui Barradas
Em 30-11-2012 17:43, Luca Meyer escreveu:
#
Hi,

I don't know if the information is still current, but there were some discussions a while back pertaining to reading Google Docs documents in R. There is a blog post here from David Smith that might be helpful:

  http://blog.revolutionanalytics.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html

I would be sure to read the comments as well.

Regards,

Marc Schwartz
On Nov 30, 2012, at 4:12 PM, Rui Barradas <ruipbarradas at sapo.pt> wrote:

            
#
On Nov 30, 2012, at 2:12 PM, Rui Barradas wrote:

            
That should be amended to read ... finding things that are in the help pages.
Rseek and Markmail are good for searching the Archives.
#
On Fri, Nov 30, 2012 at 9:43 AM, Luca Meyer <lucam1968 at gmail.com> wrote:
AFAIK, those files (*.gsheet, *.gdoc, *.gslides) are just tiny JSON
files containing references to the online/cloud resource (specifying
the "url" and the "resource_id").  There are several packages on CRAN
for parsing JSON files.  Accessing the actual online data is a
different story...

My $0.02

/Henrik