Easy cut & paste from Excel to R? 2005-02-16 - By Uwe Ligges
Peter Dalgaard wrote:
> 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"?)
>
Yes, you are right, thanks!
Uwe
______________________________________________
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
|
|
