[R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

Markus Gesmann Markus.Gesmann at libero.uk.com
Tue Nov 6 18:07:33 CET 2007


Graham,

I think you are right, it only works for a data.frame.

Cheers,

Markus

Markus Gesmann │Associate Director│Libero Ventures Ltd, One Broadgate, London EC2M 2QS
tel: +44 (0)207 826 9080│ dir: +44 (0)207 826 9085│fax: +44 (0)207 826 9090
www.libero.uk.com

AUTHORISED AND REGULATED BY THE FINANCIAL SERVICES AUTHORITY

-----Original Message-----
From: r-sig-mac-bounces at stat.math.ethz.ch [mailto:r-sig-mac-bounces at stat.math.ethz.ch] On Behalf Of Graham Smith
Sent: 06 November 2007 16:52
To: r-sig-mac at stat.math.ethz.ch
Subject: Re: [R-SIG-Mac] copying and pasting formatted output into Wordprocessor/Spreadsheet

Markus,

Thanks,

Should this work with something like the results produced by summary(x) or does it only work with data frames.

As always I find the help rather terse and impenetrable, but it seems to be aimed exporting data frames rather than analysis output tables - hopefully I have misunderstood.

Graham

On 06/11/2007, Markus Gesmann <Markus.Gesmann at libero.uk.com> wrote:
>
> Dear Graham,
>
> I use write.table to copy to the clipboard and paste into Excel on
> Windows and Mac.
> Here is an example:
>
> mydf=data.frame(x=1:10, y=letters[1:10]) write.table(mydf,
> file="clipboard", sep="\t", row.names=FALSE)
>
> Kind regards,
>
> Markus
>
> Markus Gesmann Associate DirectorLibero Ventures Ltd, One Broadgate,
> London EC2M 2QS
> tel: +44 (0)207 826 9080 dir: +44 (0)207 826 9085fax: +44 (0)207 826
> 9090 www.libero.uk.com
>
> AUTHORISED AND REGULATED BY THE FINANCIAL SERVICES AUTHORITY
>
> -----Original Message-----
> From: r-sig-mac-bounces at stat.math.ethz.ch [mailto:
> r-sig-mac-bounces at stat.math.ethz.ch] On Behalf Of Graham Smith
> Sent: 06 November 2007 15:32
> To: r-sig-mac at stat.math.ethz.ch
> Subject: [R-SIG-Mac] copying and pasting formatted output into
> Wordprocessor/Spreadsheet
>
> In Windows you can use R2HTML to copy R output into the clipboard for
> pasting into Excel as a formatted table, but this doesn't work on a Mac.
>
> Are there any obvious alternative approaches to easily paste formatted
> output into another application on the Mac.
>
> Thanks,
>
> Graham
>
>         [[alternative HTML version deleted]]
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>
> This message is intended for the personal and confidential use for the
> designated recipient(s) named above.  If you are not the intended
> recipient of this message you are hereby notified that any review,
> dissemination,  distribution or copying of this message is strictly
> prohibited. This communication is for information purposes only and
> should not be regarded as an offer to sell or as a solicitation of an
> offer to buy any financial product, an official confirmation of any
> transaction or as an official statement of Libero Ventures Ltd.  Email
> transmissions cannot be guaranteed to be secure or error-free.
> Therefore we do not represent that this information is complete or
> accurate and it should not be relied upon as such.  All information is subject to change without notice.
>

        [[alternative HTML version deleted]]


This message is intended for the personal and confidential use for the designated recipient(s) named above.  If you are not the intended recipient of this message you are hereby notified that any review, dissemination,  distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction or as an official statement of Libero Ventures Ltd.  Email transmissions cannot be guaranteed to be secure or error-free. Therefore we do not represent that this information is complete or accurate and it should not be relied upon as such.  All information is subject to change without notice.


More information about the R-SIG-Mac mailing list