Message-ID: <x28y5oiy5d.fsf@biostat.ku.dk>
Date: 2005-02-16T10:42:38Z
From: Peter Dalgaard
Subject: Easy cut & paste from Excel to R?
In-Reply-To: <42132387.8060109@statistik.uni-dortmund.de>
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