[R] Transferring R results to word prosessors

[Gabor Grothendieck]

Yes, the R2HTML route is probably the quickest.  Its just one line
of code (plus the call to load in R2HTML).  Try this where iris
is a data set built into R:

   library(R2HTML)
   HTML( iris, file("clipboard","w"), append=FALSE )

Now paste the clipboard into Excel and from there into Word.

(If you are using OO Calc instead of Excel then you need to do:
    Edit | Paste Special | HTML Format | OK
in Calc.)

On 2/9/06, Tom Backer Johnsen <backer at psych.uib.no> wrote:
> There has been an incredible number of responses in a short time, with a
> number of different suggestions.  With hindsight, I must admit I have not
> been quite clear, so additional (somewhat lengthy) explanation is needed.
>
> I want to use R in an introductory course on multiple regression (among
> other things) starting in two weeks time for students of psychology at my
> University.  These students are very much used to MS Word, it is in
> principle possible to get them to adopt OpenOffice (which I would like to),
> but I regard Latex to be out of the question.
>
> One of the things they are drilled on is that they have to produce term
> papers etc. based on a template in APA (American Psychological Association)
> format.  Among other things, this means that the document must be all text
> apart from the graphics.  Therefore any kind of solution involving pictures
> of tables rather than the tables / results as text is out.  Same holds for
> all kinds of "mixed" output, so combinations of text with PDF
> elements.  Besides, the tables in R are not that nice in respect to the
> formatting.  Since the content is the main thing anyhow, that does not
> matter.  In most cases, the tables have to be tweaked as least to some
> extent.  Given my inexperience, it seems that the R2HTML path is so far the
> most promising (but for me untried so far)
>
> One of the nice things about SPSS and Statistica is that it is VERY easy to
> copy and paste output from the program right into the paper / paper.  A
> commmon trick when using SPSS is to first paste the output into a
> spreadsheet (e.g. Excel), and from there into the document.  In any case,
> the outcome is that the output is a table (not a table in the R sense) in
> the document, which may be edited, tweaked, adding borders etc..  So, what
> I am looking for is a process starting with output from R (like what is
> obtained from the summary(lm (...)) command, the output of a correlation
> matrix, or ...) that could end up as a table in MS Word (and probably in
> OpenOffice as well) in the smallest number of steps.
>
> For instance, if there was an option in R which had the effect that the
> spaces separating things (e.g. the columns in the output of a correlation
> matrix or the elements in an ANOVA table) were replaced by tabs, everything
> would be very simple.  Then, you could (a) paste the output into the
> document, and (b) do a simple text-to-table conversion in Word after the
> paste.  A simple affair with a few simple steps.  Ideally, what I want for
> me and my students is this or a similar solution to this problem.  That
> might be a good selling argument for R as well.
>
> Tom
>
> ______________________________________________
> 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
>