[R] import Excel file ?
Gabor Grothendieck
ggrothendieck at myway.com
Tue Apr 20 17:13:13 CEST 2004
Emilie Haon.Lasportes <Emilie.Haon-Lasportes <at> beaulieu.rennes.inra.fr>
writes:
> I would like to know how can I import Excel files in R ? Do I have to
> transform them in text files (.txt) ?
The easiest way for one time use is to select the data in Excel,
press ctrl-c to copy it to the clipboard and
then use the following R command:
read.table("clipboard", header=T)
(assuming the first selected line is the header).
More information about the R-help
mailing list