[R] How to copy Excel numbers at the R prompt

From: G. Draisma <g.draisma_at_erasmusmc.nl>
Date: Wed, 26 Mar 2008 11:08:43 +0100


Dear all,
I was wonderin how to copy data from an Excel sheet to the R prompt.

For a single culumn it works
to select the data in Excel,
copy to the clipboard with ctrl-c
and to use in R:



x<-scan()
[paste data with ctrl-v (paste)]
[ctrl-z, to end input]

But with multiple columns Excels tabs
are "eaten" by the R-promt, and
the numbers concatenated without separator.

Is there a handy method for this?

Thanks,
Gerrit.

-- 
Gerrit Draisma
Department of Public Health
Erasmus MC, University Medical Center Rotterdam
Room AE-103
P.O. Box 2040 3000 CA  Rotterdam The Netherlands
Phone: +31 10 7043124 Fax: +31 10 010-7038474
http://mgzlx4.erasmusmc.nl/pwp/?gdraisma

______________________________________________
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.
Received on Wed 26 Mar 2008 - 10:11:06 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 26 Mar 2008 - 10:30:25 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive