search for: getworksheet

...essing my data in google spreadsheets. I get the message: "problems connecting to get the list of documents" when I use getDocs, despite being logged in e.g. sheets.con = getGoogleDocsConnection(getGoogleAuth("username", "password", service = "wise")) ts = getWorksheets("formname", sheets.con) è Error in getDocs(con) : problems connecting to get the list of documents Does anyone know what might be causing this? Is it maybe a problem at the google end? Matthew Blackett Researcher King's College London http://geography.kcl.ac.uk/micromet/MBlacket...

Hello, Some code using RGoogleDocs, which had been working smoothly since the summer, just stopped working. I know that it worked on November 3rd, but it doesn't work today. I've confirmed that the login and password still work when I log in manually. I've confirmed that the URL gives the same error when I paste it into Firefox. I don't know enough about this web service to figure

...uot;) > options(RCurlOptions = list(capath = system.file("CurlSSL", "cacert.pem", > package = "RCurl"), ssl.verifypeer = FALSE)) > sheets.con = getGoogleDocsConnection(getGoogleAuth("fjbuch at 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 com...

...the path. RgoogleDocs 0.2-2 is amazing. I can now read data straight into a dataframe.. The fact that I am always reading from realtime data is astounding. sheets.con = getGoogleDocsConnection(getGoogleAuth("fjbuch@gmail.com", "password here", service = "wise")) ts2=getWorksheets("Consents Received",sheets.con)# put the name of the spreadsheet in the inverted commas names(ts2) sheetAsMatrix(ts2$Sheet1,header=TRUE, as.data.frame=TRUE, trim=TRUE) MAGIC Boy oh boy that process of getting source to binary was super painful. Now that I have the package as binary I c...