tag:blogger.com,1999:blog-6208519949676270052.post5304175969989205758..comments2023-02-12T02:45:39.985+01:00Comments on Apply R: Toying with Google Apps ScriptPůlnoční běžechttp://www.blogger.com/profile/15968750617146554594noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6208519949676270052.post-49890391101914439702012-01-12T09:42:35.326+01:002012-01-12T09:42:35.326+01:00You need to publish the document (File -> Publi...You need to publish the document (File -> Publish to the web -> Publish).<br /><br />Next, I believe your first line should be the following<br /><br />data <- read.csv("http://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AtV5LpX5WI3_dGQzeDZvdEJ2UGxPLVBoa0N2ajBSc3c&output=csv", header=FALSE, skip=1, as.is=TRUE)<br /><br />If still not working, just download the csv file to your disk (File -> Download as -> CSV) and work offline. <br /><br />Greetings to Amsterdam,<br /><br />PetrPůlnoční běžechttps://www.blogger.com/profile/15968750617146554594noreply@blogger.comtag:blogger.com,1999:blog-6208519949676270052.post-33782775829840971082012-01-12T09:06:58.745+01:002012-01-12T09:06:58.745+01:00I am trying to run your script however i encounter...I am trying to run your script however i encounter the following error when execute the first line.<br /><br />datat <- read.csv("https://docs.google.com/spreadsheet/ccc?key=0AtV5LpX5WI3_dGQzeDZvdEJ2UGxPLVBoa0N2ajBSc3c", header = FALSE, skip = 1, as.is = TRUE)<br />Error in file(file, "rt") : cannot open the connection<br />In addition: Warning message:<br />In file(file, "rt") : unsupported URL schemeAnonymousnoreply@blogger.com