[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