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

[Peter Dalgaard]

Uwe Ligges <ligges at statistik.uni-dortmund.de> writes:

> Well, yes, some arguments twisting might be required as for my german
> locales / german version of Excel the following works even for empty
> cells and real valued entries:
> 
>    read.table(file("clipboard"), sep="\t", dec=",")
> 
>     V1  V2  V3
> 1 1.2  NA 2.3
> 2 3.4 4.5 5.6

...which is of course the same as 

     read.delim2(file("clipboard"), header=FALSE)

except for possible variations in the fill and quote settings. (What
happens if you have empty cells in the last columns, or cells with
the text "Don't do this"?)

-- 
   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907