In Using Google Spreadsheets as a Database Source for R, I described a simple Google function for pulling data into R from a Google Visualization/Chart tools API query language query applied to a Google spreadsheet, given the spreadsheet key and worksheet ID. But how do you get a list of sheets in spreadsheet, without opening 
In our last entry, we described reading Excel files. In this entry, we do the opposite: write native Excel files.RIn R, the WriteXLS package provides this functionality. It uses perl to do the heavy lifting, and the main complication is to install th...
I have found myself over the years in a rather awkward situation. I work in old-school, bricks and mortar industry IT shops for the most part. However, I love many open source projects and identify with many of the values of start up cultur...
The R software is very powerful and flexible but one of the complaints of new users is that the learning curve is steep and can be daunting. There have been various projects to create GUIs for R with varying levels of sophistication, one of which is R Commander by John Fox. Fast Tube by Casper This interface
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
