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

Gabor Grothendieck ggrothendieck at myway.com
Wed Feb 16 15:46:36 CET 2005


Peter Dalgaard <p.dalgaard <at> biostat.ku.dk> writes:

: 
: 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)

which is the same as

       read.delim2("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"?)
:




More information about the R-help mailing list