[R] Requery: R 1.0.0 for Win95 and clipboard -Reply

Andrew Bernat andrew.bernat at bea.doc.gov
Thu Mar 23 14:14:31 CET 2000


For small datasets it would be useful to be able to copy a block of data from a spreadsheet then toggle over to R and just paste it in.  If it's possible, having read.table access the clipboard (e.g. x <- read.table(file="clipboard", ...) would do the trick.  Of course, exporting to a file and the reading into R is pretty easy but usring the clipboard would save a couple extra steps.

Andy Bernat

>>> Peter Dalgaard BSA <p.dalgaard at biostat.ku.dk> 03/23/00 05:25am >>>
Ursula Kellett <u.kellett at qut.edu.au> writes:

> Noone answered so I guess this is not possible, but can anyone definitely put
> me out of my misery...
> 
> 'I have just begun using R 1.0.0 for Win95. Can someone please tell me  how to
> put a data frame on the clipboard, and how to read data into a  data frame
> from the clipboard.'
> 
> Is this something that's planned? The clipboard seems pretty fundamental to
> Windows (and other OS?).

The short answer is "no", but most people in the developer crowd come
from a Unix background, so there may be some useful techniques we just
don't know about. Some work has been done on communication with Excel
and using (D)COM.

Counterquestion: How would you expect it to work? What would you do
with it once it was on the clipboard and how would you ensure that
data contained the relevant information (factor levels, e.g.) when
read from the clipboard? What are the relevant communication channels?

-- 
   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
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list