[R] Read in from multiple Excel wksheets

[Ben Bolker]

dM/ <david.n.menezes <at> gmail.com> writes:

> 
> I’ve got an Excel workbook with about 30 worksheets.  Each worksheet
> has 10000 rows of data over 30 columns.
> 
> I’d like to read the data from each worksheet into a dataframe or
> matrix in R for processing.  Normally, I use read.csv when interacting
> with Excel but I’d rather manipulate a multisheet workbook directly
> than set about splitting the original workbook and saving down each
> part as a csv.
> 
[snip]
> However, when I try to apply this to my real, large workbook, things
> go wrong, with the following error message.  Any ideas/workarounds?
> 

  Try read.xls from the gdata package?
  Or see http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel
for more suggestions on I/O between R and Excel.