[R] Automatic datasets creation from multiple data sheets in a single excel file

[Dieter Menne]

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.