Re: [R] pasting results into Word/Excel

2004-04-12 Thread Graham M Smith
Thomas, My current approach for model summaries is to use the xtable package and write things as HTML tables. It was an HTML approach that Gabor suggested,using R2HTML, and that worked well, but I will try xtable as well. As always with R, there is a solution if you know where to look.

[R] pasting results into Word/Excel

2004-04-11 Thread Graham M Smith
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. Or is there some other way of doing this to avoid the time spent reformatting the output for presentation. If different, I am also interested in an

Re: [R] pasting results into Word/Excel

2004-04-11 Thread Graham M Smith
Anders, This seems a good start, and I will try it get it to work, on of the issues is that the results output is more complex than simply split by comma eg a typical Summary output of my current data set (below) However, I am a lot further forward than I was a few hours ago. Thanks

Re: [R] pasting results into Word/Excel

2004-04-11 Thread Graham M Smith
Uwe, To copy/paste your data.frame X to Excel, use the following lines to write it to the clipboard from R: Thanks, this is certainly a step in the right direction, it doesn't work as it stands but it has given me a start If different, I am also interested in an answer to the same

Re: [R] pasting results into Word/Excel

2004-04-11 Thread Graham M Smith
Gabor, : Is there some clever way of pasting results from R into Excel or Try this: data(iris) # get a test data frame require(R2HTML) HTML( iris, file(clipboard,w), append=F ) This worked exactly as I was hoping. Many thanks, Graham