[R] how to import data from excel to R

jim holtman jholtman at gmail.com
Wed Nov 14 18:25:55 CET 2012


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.

On Wed, Nov 14, 2012 at 8:45 AM, shwetank <shwetank at iasri.res.in> wrote:
> 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.




More information about the R-help mailing list