rajclinasia wrote:
>
> Please let us know how to create automatic datasets from multiple data
> sheets in a single excel file...
>
> For example if there are 10 sheets in a single excel file, automatically
> 10 datasets need to be created at a time when i read an excel file as a
> whole at once.
>
>
The critical part is getting the names of the worksheets.
http://tolstoy.newcastle.edu.au/R/e6/help/09/03/7736.html
For reading individual worksheets, there is lots of code around.
And a site search for "read excel worksheet" returns quite a few references.
Dieter
--
View this message in context:
http://www.nabble.com/Automatic-datasets-creation-from-multiple-data-sheets-in-a-single-excel-file-tp24754120p24756406.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.