[R] Import more than one sheet in a single excel file

Gabor Grothendieck ggrothendieck at gmail.com
Tue Aug 11 15:46:36 CEST 2009


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<raj at 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 at 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.
>




More information about the R-help mailing list