[R] How to copy Excel numbers at the R prompt
Uwe Ligges
ligges at statistik.tu-dortmund.de
Wed Mar 26 11:13:08 CET 2008
Use
read.delim("clipboard")
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.
>
>
More information about the R-help
mailing list