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

[Uwe Ligges]

Peter Dalgaard wrote:

> 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"?)
> 

Yes, you are right, thanks!

Uwe