[R] [FORGED] Export R output in Excel

[peter dalgaard]

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.turner at 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 at 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.mes at cbs.dk  Priv: PDalgd at gmail.com