 | | | Easy cut & paste from Excel to R? | Easy cut & paste from Excel to R? 2005-02-16 - By Peter Dalgaard
Uwe Ligges <ligges@(protected)> writes:
> Werner Wernersen wrote:
>
> > Hi!
> > Is it possible to easily cut & paste data from an
> > Excel spreadsheet to an R edit( ) grid or to variable?
> > It seems that R cannot handle the cell delimiters
> > Excel hands over.
> > Regards,
> > Werner
> > ______________________________________________
> > 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
>
> copy in Excel and say in R:
> read.table(file("clipboard"))
Er, doesn't that want to be read.delim (or read.delim2 in
"comma-locales")? Plain read.table() could cause some grief if there
are empty cells.
--
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
|
|
|
