Re: [R] Reading .gsheet within R

2012-12-01 Thread Luca Meyer 
Thank you Henrik  the others that have commented. Accessing the actual online 
data is what I would need, but apparently this is not yet feasible…
Luca


Il giorno 01/dic/2012, alle ore 04:53, Henrik Bengtsson h...@biostat.ucsf.edu 
ha scritto:

 On Fri, Nov 30, 2012 at 9:43 AM, Luca Meyer lucam1...@gmail.com wrote:
 Hello R-experts,
 
 I would like to know if there is a solution to read files with extension 
 .gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for 
 more info on this file format.
 
 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
 
 
 Thank you,
 Luca
 
 Mr. Luca Meyer
 www.lucameyer.com
 R 2.15.1
 Mac OS X 10.8.2
 
 
 
 
 
 
 
[[alternative HTML version deleted]]
 
 __
 R-help@r-project.org mailing list
 https://stat.ethz.ch/mailman/listinfo/r-help
 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
 and provide commented, minimal, self-contained, reproducible code.

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] Reading .gsheet within R

2012-11-30 Thread Luca Meyer 
Hello R-experts,

I would like to know if there is a solution to read files with extension 
.gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for more 
info on this file format.

Thank you,
Luca

Mr. Luca Meyer
www.lucameyer.com
R 2.15.1
Mac OS X 10.8.2







[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Reading .gsheet within R

2012-11-30 Thread Rui Barradas 

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:

Hello R-experts,

I would like to know if there is a solution to read files with extension 
.gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for more 
info on this file format.

Thank you,
Luca

Mr. Luca Meyer
www.lucameyer.com
R 2.15.1
Mac OS X 10.8.2







[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Reading .gsheet within R

2012-11-30 Thread Marc Schwartz 
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 ruipbarra...@sapo.pt wrote:

 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:
 Hello R-experts,
 
 I would like to know if there is a solution to read files with extension 
 .gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for 
 more info on this file format.
 
 Thank you,
 Luca
 
 Mr. Luca Meyer
 www.lucameyer.com
 R 2.15.1
 Mac OS X 10.8.2

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Reading .gsheet within R

2012-11-30 Thread David Winsemius 

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

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

That should be amended to read ... finding things that are in the help pages.

 
 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.

Rseek and Markmail are good for searching the Archives.

-- 
David.
 
 
 So I guess there's nothing yet.
 
 Hope this helps,
 
 Rui Barradas
 Em 30-11-2012 17:43, Luca Meyer escreveu:
 Hello R-experts,
 
 I would like to know if there is a solution to read files with extension 
 .gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for 
 more info on this file format.
 
 Thank you,
 Luca
 
 Mr. Luca Meyer
 www.lucameyer.com
 R 2.15.1
 Mac OS X 10.8.2
 
 
 
 
 
 
 
  [[alternative HTML version deleted]]
 
 __
 R-help@r-project.org mailing list
 https://stat.ethz.ch/mailman/listinfo/r-help
 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
 and provide commented, minimal, self-contained, reproducible code.
 
 __
 R-help@r-project.org mailing list
 https://stat.ethz.ch/mailman/listinfo/r-help
 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
 and provide commented, minimal, self-contained, reproducible code.

David Winsemius, MD
Alameda, CA, USA

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Reading .gsheet within R

2012-11-30 Thread Henrik Bengtsson 
On Fri, Nov 30, 2012 at 9:43 AM, Luca Meyer lucam1...@gmail.com wrote:
 Hello R-experts,

 I would like to know if there is a solution to read files with extension 
 .gsheet directly into R - see http://www.fileinfo.com/extension/gsheet for 
 more info on this file format.

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


 Thank you,
 Luca

 Mr. Luca Meyer
 www.lucameyer.com
 R 2.15.1
 Mac OS X 10.8.2







 [[alternative HTML version deleted]]

 __
 R-help@r-project.org mailing list
 https://stat.ethz.ch/mailman/listinfo/r-help
 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
 and provide commented, minimal, self-contained, reproducible code.

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.