Easy cut & paste from Excel to R?
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