[R] Easy cut & paste from Excel to R?

Uwe Ligges ligges at statistik.uni-dortmund.de
Wed Feb 16 10:14:52 CET 2005


Werner Wernersen wrote:

> Hi!
> 
> Is it possible to easily cut & paste data from an
> Excel spreadsheet to 
> an R edit( ) grid or to variable?
> It seems that R cannot handle the cell delimiters
> Excel hands over.
> 
> Regards,
>   Werner
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

copy in Excel and say in R:
read.table(file("clipboard"))

Uwe Ligges




More information about the R-help mailing list