Message-ID: <1352900742982-4649487.post@n4.nabble.com>
Date: 2012-11-14T13:45:42Z
From: shwetank
Subject: how to import data from excel to R
In-Reply-To: <e702b59235da911d83c8f6f6f78724da.squirrel@mail.spectrum.net.in>
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.