Gabor Grothendieck <ggrothendieck <at> myway.com> writes: > > Graham M Smith <graham.smith <at> myotis.co.uk> writes: > > : Is there some clever way of pasting results from R into Excel or Word, as > : tab limited format so they are easy to turn into a formatted table. > > Try this: > > data(iris) # get a test data frame > require(R2HTML) > HTML( iris, file("clipboard","w"), append=F ) > > Now go to Excel and press ctrl-V to paste it in. > Once its in Excel you can copy and paste from there to Word.
I noticed that your response to other respondents indicate that you want to display a summary. Try something like this with the above approach: HTML.matrix( summary(iris), file("clipboard", "w"), append=F ) # paste into Excel In Excel, with the table selected, you may wish to - set the cell width (Format | Column | Width) wider, say 12, and - right justify the matrix (click on right justify icon in toolbar) ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html