[R] Easy cut & paste from Excel to R?

[Peter Dalgaard]

Uwe Ligges <ligges at statistik.uni-dortmund.de> 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 at stat.math.ethz.ch 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 at biostat.ku.dk)             FAX: (+45) 35327907