Dear Farrel, Now, using the most updated version of the packages, I was able to make your example work for me - thank you very much for your help!
Best, Tal ----------------Contact Details:------------------------------------------------------- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com (English) ---------------------------------------------------------------------------------------------- On Fri, Nov 19, 2010 at 10:27 PM, Farrel Buchinsky <fjb...@gmail.com> wrote: > Harlan and Tal have had problems. I had lots too. I spent hours getting it > to work. Terrible process to go through but RGoogleDocs is so useful that > the time was worth it - I think! > > My problems were overcome when > > 1. I used the latest zip file by Duncan Temple Lang see below > 2. I inserted an options line that loosened the ssl security - do not > know if that was a good thing or not but it got it to work > > Duncan said: > "I have put an updated version of the source of the package with > these changes. It is available from > http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.tar.gz > There is a binary for Windows in > http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.zip > > Here is my script that works. Does yours look like this? > > library(RGoogleDocs) > packageDescription("RGoogleDocs") > ps <-readline(prompt="get the password in ") > options(RCurlOptions = list(capath = system.file("CurlSSL", "cacert.pem", > package = "RCurl"), ssl.verifypeer = FALSE)) > sheets.con = getGoogleDocsConnection(getGoogleAuth("fjb...@gmail.com", ps, > service ="wise")) > ts2=getWorksheets("OnCall",sheets.con) #OnCall is just the name of a > spreadsheet > names(ts2) > y2005<-sheetAsMatrix(ts2$y2005,header=TRUE, as.data.frame=TRUE, trim=TRUE) > > Finally, I am willing to offer you a TeamViewer session where we can take > control of one another's computers and see if the problem is code or the > installation. I warn you that I am neither a programmer nor a developer, > just a very enthusiastic RGoogleDocs user who probably perseveres more than > is good for him. > > Farrel Buchinsky > > [[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.
