Posts Tagged ‘ spreadsheet ’

Google Spreadsheets API: Listing Individual Spreadsheet Sheets in R

September 7, 2011
By
Google Spreadsheets API: Listing Individual Spreadsheet Sheets in R

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

Read more »

Example 8.38: WriteXLS to create spreadsheets

May 16, 2011
By
Example 8.38: WriteXLS to create spreadsheets

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...

Read more »

Thoroughly Unusual Itches

July 23, 2010
By
Thoroughly Unusual Itches

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...

Read more »

R Commander – a good introductory GUI for R

June 1, 2010
By
R Commander – a good introductory GUI for R

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

Read more »