In read.xls in the gdata package there is an argument that is 1 for the first sheet, 2 for the second, etc. If you run it with verbose = TRUE it will tell you how many sheets are there.
On Tue, Aug 11, 2009 at 9:09 AM, rajclinasia<r...@clinasia.com> wrote: > > Hi Every one, > my question is, How to Import more than one sheet in a single excel file > (e.g. 10 sheets in one excel file) into R and create datasets for all the > sheets in a single excel file without specifying the sheetnames. > > Thank you in Advance. > > > -- > View this message in context: > http://www.nabble.com/Import-more-than-one-sheet-in-a-single-excel-file-tp24917331p24917331.html > Sent from the R help mailing list archive at Nabble.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. > ______________________________________________ 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.
