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. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
