search for: sheetasmatrix

The author of the package, Duncan Temple Lang posted an update. I have installed it and now can list my spreadsheets but alas I cannot read the data within any of them. Has anybody been able to get it to work. I would love to see a real live example of sheetAsMatrix I am not sure how to specify sheet and con = sheet@connection. I have tried many ways but just get: Error in !includeEmpty : invalid argument type Windows Vista (with UAC disabled) R 2.9.0 Farrel Buchinsky [[alternative HTML version deleted]]

...whose value was created by simply using the value from the cell immediately to the left in the Google spreadsheet I would prefer to get the value rather than =RC[-1] When one exports with Google Spreadsheets as a csv then that does not happen. I am using the following line of code in R y2009<-sheetAsMatrix(ts2$y2009,header=TRUE, as.data.frame=TRUE, trim=TRUE) Farrel Buchinsky Google Voice Tel: (412) 567-7870 [[alternative HTML version deleted]]

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

...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 can share the whole folder with my coworker and she is able to use RGoogleDocs. I intend to use the same process for the othe...

...slightly different approach (and function) > to pull the values into the form of an R data frame. > > Please try that and hopefully it will work. > > The code in the run.pdf (or run.html) file on the Web page > and in the package works and is the best and shortest > example of sheetAsMatrix(). > > Let me know if there are still problems. > > >  D. > > Farrel Buchinsky wrote: > >> The author of the package, Duncan Temple Lang posted an update. I have >> installed it and now can list my spreadsheets but alas I cannot read the >> data within any...

...ot;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 computers and see if the problem is code or the > installation. I warn you that I am neither a programmer nor a developer, &...