Easy cut & paste from Excel to R? 2005-02-16 - By Peter Dalgaard
Uwe Ligges <ligges@(protected)> 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@(protected)) FAX: (+45) 35327907
______________________________________________
R-help@(protected) mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
|
|
