On Wed, Sep 11, 2013 at 9:06 AM, Charles Determan Jr <deter...@umn.edu> wrote: > If there isn't multiple sheets you can use the 'gdata' package and > read.xls(). > > Otherwise you could re-save the file as a csv file and load that file with > read.csv() assuming not multiple sheets again which a csv cannot contain. >
read.xls in gdata does support multiple sheets via the sheet= argument as well as the sheetCount and sheetNames helper functions. fn <- "abc.xlsx" nms <- sheetNames(fn) lapply(nms, read.xls, xls = fn) -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ 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.
