I don't really disagree with the below, but part of the issue is that analyses do not typically output results in data frame like formats (neither in the textual form or as R objects). Some people have attacked this issue by wrangling output into data frames, check the "broom" package.
(The ideology of sweeping much of the flexibility of R away by turning all data structures into data sets strikes me a bit much like reinventing SAS, but this might be a spot where it comes in useful.) -pd > On 29 Dec 2016, at 01:05 , Rolf Turner <r.tur...@auckland.ac.nz> wrote: > > On 29/12/16 12:48, Bryan Mac wrote: >> Hi Rolf, >> >> I wanted to export the output/results of R to an Excel file for >> easier comparisons/reporting. When I tried to copy and paste my >> output to an excel file the formatting was off. I want to export my >> descriptive stats and the linear regression. > > This makes little to no sense to me. Spreadsheets are for use in storing > data, not for displaying the output of analyses. (I know that Excel users do > this sort of thing, but then people do all sorts of irrational things.) > >> I googled “Export R output to excel” but did not find most of the >> hints “useful”. if anything, it got me more confused. >> >> Thanks. > > (1) The best advice is still "*Don't*." > > (2) You do not need Excel to make comparisons and report. In fact it is a > handicap. Re-think your strategy. > > (3) If you insist in proceeding in a wrong-headed manner, isn't the item > about XLConnect (3rd answer, 1st hit) "useful"? > > cheers, > > Rolf Turner > > -- > Technical Editor ANZJS > Department of Statistics > University of Auckland > Phone: +64-9-373-7599 ext. 88276 > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. -- Peter Dalgaard, Professor, Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Office: A 4.23 Email: pd....@cbs.dk Priv: pda...@gmail.com ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
