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 [EMAIL PROTECTED] 801.408.8111 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > project.org] On Behalf Of Tom Backer Johnsen > Sent: Sunday, October 26, 2008 7:58 AM > To: [EMAIL PROTECTED] > 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@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.
