[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> 
> 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