You may want to try the odfWeave package. It uses openoffice which can read and write MSWord documents. This is an alternative to the HTML > Excel > Word route.
-- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare [EMAIL PROTECTED] 801.408.8111 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > project.org] On Behalf Of Tom Backer Johnsen > Sent: Friday, October 24, 2008 1:31 PM > To: [EMAIL PROTECTED] > Subject: [R] Transferring results from R to MS Word > > R-users > > At the moment I am teaching a course on the use of R for data analysis. > Part of course requirements involves the transfer of results from R > to > something that resembles the APA (American Psychological Associations) > type tables to MS Word. Until now I have used the HTML function in the > R2HTML library, with a call like this: > > HTML(summary(model1), file("clipboard", "w"), digits=4) > > Where "model1" is an object containing results from a linear model > (function lm ()). I have to add that I do not remember where I got the > digits argument from. The main point is that the output is transferred > to Excel as the first step where the output can be deleted and shuffled > in order to produce a correctly formatted table according to APA > standards which then is transferred to MS Word with a copy and paste > operation. > > The problem is simply that what is tranferred to Excel varies with what > you throw at the HTML function. Nothing is rounded of with an lm() > model. With a function like sd () I seem to consistently get 2 decimal > points transferred, less than what I want, while there are variations > in > respect to the number of decimals when I transfer the result on the > summary () using a frame as the argument. > > The optimal thing for me (and the students) would be to consistently > have all the decimals tranferred to Excel, any rounding to could be > done > there before the transfer of the table to MS Word. Alternatively, that > something like the argument digits=x works in a consistent manner with > at least most objects. > > So: > > What do I tell my students on what to do using R2HTML in order to > obtain > consistent results? > > Alternativly: are there other alternatives I and my students could use > for the transfer of results from R via Excel to MS Word? > > I really would appreciate some suggestions. > > Tom > > ______________________________________________ > R-help@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. ______________________________________________ R-help@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.
