Read all worksheets in an Excel workbook into an R list with data.frames
Updated answer using readxl (22nd June 2015) Since posting this question the readxl package has been released. It supports both xls and xlsx format. Importantly, in contrast to other excel import packages, it works on Windows, Mac, and Linux without requiring installation of additional software. So a function for importing all sheets in an Excel … Read more