From ggrothendieck at gmail.com  Wed Mar 29 05:08:40 2006
From: ggrothendieck at gmail.com (Gabor Grothendieck)
Date: Tue, 28 Mar 2006 22:08:40 -0500
Subject: [Rd] Wishlist - access non-text from clipboard in Windows
In-Reply-To: <44272DBD.1030707@stats.uwo.ca>
References: <971536df05092208135b7ff57d@mail.gmail.com>
	<4332DEEA.8090705@stats.uwo.ca>
	<971536df050922101246bf8667@mail.gmail.com>
	<4332F2D3.6000807@stats.uwo.ca>
	<971536df050922115057416498@mail.gmail.com>
	<44272DBD.1030707@stats.uwo.ca>
Message-ID: <971536df0603281908j47836d85t3e5ca257b3e5e15e@mail.gmail.com>

Hi, I am just trying it now.  Suppose I copy the first few lines of
the table at:

http://www.pricelesswarehome.org/2006/CumulativePL.php

into the clipboard by selecting them with the mouse in IE and
pressing ctrl-C.  Now I can just go to Excel, click on a cell
and press ctrl-V and they get pasted as cells.  In fact,
that is usually what I would do: paste it into Excel and then
transfer it to R.

Is this correct?

readClipboard(49340)  # got number from getClipboardFormats()

and then parse the HTML that I get from that.

I guess what would be nice would be if one could somehow use
read.table to read it in and directly get a data frame out.

Regards.


On 3/26/06, Duncan Murdoch <murdoch at stats.uwo.ca> wrote:
> I've just committed some code to R-devel to allow clipboard access to
> non-text in Windows.  This was something we discussed last September.
> I'm not completely happy with the code (it works with numerical
> clipboard format numbers rather than translating them into their names),
> but I'd rather make it available than work on it any more.
>
> Duncan Murdoch
>



[Rd] Wishlist - access non-text from clipboard in Windows
Gabor Grothendieck