The simplest way, in my opinion is:
>save .xls file as .csv in ms excel "save as" option. csv means comma
delimited.
>now type following command on R console;
>mydata<-read.csv(file.choose())
this will open a dialog box will open and select your .csv
file.
now the data will be saved as "mydata" is actually a data frame.
Enjoy,
regards.
--
View this message in context:
http://r.789695.n4.nabble.com/how-to-import-data-from-excel-to-R-tp966629p4649487.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.
