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

From: Uwe Ligges <>
Date: Wed, 26 Mar 2008 11:13:08 +0100


Uwe Ligges

G. Draisma wrote:
> 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.
> mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Wed 26 Mar 2008 - 10:15:45 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 - 11:30:27 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive