how to import data from excel to R

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.
Also checkout the XLConnect package since it can read/write EXCEL
files directly so that you do not have to go through the step of
creating a CSV file.  Really nice when you want to create an Excel
file with multiple worksheets containing different phases of your
analysis.
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 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.

Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
Um texto embutido e sem conjunto de caracteres especificado foi limpo...
Nome: n?o dispon?vel
Url: <https://stat.ethz.ch/pipermail/r-help/attachments/20121114/ab2964f2/attachment.pl>