[R] Transferring results from R to MS Word

[Greg Snow]

Another alternative (since you asked) is the RExcel project (http://rcom.univie.ac.at).  I don't know if it will work better for your projects or not, but it may be worth a look.  The basic idea is that it uses Excel as a front end and R as the background computational engine as an Excel plugin.  It has tools for transferring data automatically between Excel and R that may be easier for what you want (or not).  There are also mechanisms for putting R code in a cell, having the code run through R and the output put into other cells in the spreadsheet.

Hope this helps,

--
Gregory (Greg) L. Snow Ph.D.
Statistical Data Center
Intermountain Healthcare
greg.snow at imail.org
801.408.8111


> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of Tom Backer Johnsen
> Sent: Sunday, October 26, 2008 7:58 AM
> To: r-help at stat.math.ethz.ch
> Subject: Re: [R] Transferring results from R to MS Word
>
> To reply to myself, for anything that can be coerced into a table
> (matrices, vectors) the best solution seems to to use the write.table
> ()
> function to write a .csv file, which is easily opened with a
> spreadsheet.
>
> The alternative is to use the HTML2clip () function (or the HTML
> function) in the R2HTML library and then paste the clipboard into
> Excel.
>   That alternative seems to be OK for objects as returned by the lm ()
> function, but little else.  Among other things, the function is
> extremely heavyhanded in respect to rounding.  To see what I mean, try
> HTML2clip (mean(attitude)).
>
> So, are there any other alternatives?
>
> Tom
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-
> guide.html
> and provide commented, minimal, self-contained, reproducible code.