spicyose.blogg.se

In Google spreadsheets, choose File/Publish to the web.This is a one-time operation that will continue to work even if you add more data to the spreadsheet. You will have to set up your spreadsheet on Google to talk with R. (See below for how to read Google spreadsheets without fetchGoogle.) On many systems, it is very easy on others it is not possible unless you have some detailed knowledge of how to install command-line software. If you are running R on your own desktop rather than using a server, try installing RCurl. The server does not (as of the time of this writing).) The server at Macalester does have RCurl installed. If it is, then you're good to go with the fetchGoogle method. How Will I Know What to Do?Ĭheck whether the RCurl package is installed on your system. Otherwise, there is a multi-step process that is not too difficult. Google spreadsheets is a useful tool for this.įor those implementations of R that support the web protocol used by Google, there is a simple way to read Google spreadsheets into R via the fetchGoogle function in the mosaic package. It's helpful to be able to collaborate in collecting data. Reading in Google Spreadsheets to R Reading in Google Spreadsheets to R