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.
