Re: [R] [FORGED] Export R output in Excel

2016-12-30 Thread John McKown
On Thu, Dec 29, 2016 at 4:32 PM, Erich Subscriptions < erich.s...@neuwirth.priv.at> wrote: > Just a very brief footnote. > I is easy to write badly structured spreadsheets. > But if people dong this would not have spreadsheets > and be forded to write code, they probably also > would write badly

Re: [R] [FORGED] Export R output in Excel

2016-12-29 Thread Erich Subscriptions
Just a very brief footnote. I is easy to write badly structured spreadsheets. But if people dong this would not have spreadsheets and be forded to write code, they probably also would write badly structured code. There is a lot of bad R code around also! > On Dec 29, 2016, at 15:40, Bert

Re: [R] [FORGED] Export R output in Excel

2016-12-29 Thread Bert Gunter
Oh nuts! I replied all. I apologize for the noise! Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Thu, Dec 29, 2016 at 6:40 AM, Bert Gunter

Re: [R] [FORGED] Export R output in Excel

2016-12-29 Thread Bert Gunter
(Private -- as this is just my personal opinion and not really helpful). I found your comments informative. Thank you. My own experience with scientific colleagues -- biologists mostly -- who use Excel in the way that you describe is that the "haptic" (great word!) ease with which they

Re: [R] [FORGED] Export R output in Excel

2016-12-29 Thread 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

Re: [R] [FORGED] Export R output in Excel

2016-12-29 Thread Erich Subscriptions
Well, my few cents again. the packages openxslx and xlsx allow to write dataframes as Excel sheets. (xlsx is Java based, so it has more requirements to run than openxlsx, which is just C++ based) On Windows, R tools for Visual Studio allows Excel export. For Windows, there also is our Excel

Re: [R] [FORGED] Export R output in Excel

2016-12-28 Thread Bryan Mac
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. I googled “Export R output to excel” but did

Re: [R] [FORGED] Export R output in Excel

2016-12-28 Thread Rolf Turner
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

Re: [R] [FORGED] Export R output in Excel

2016-12-28 Thread Rolf Turner
On 29/12/16 10:45, Bryan Mac wrote: Hi, How do I export results from R to Excel in a format-friendly way? For example, when I copy and paste my results into excel, the formatting is messed up. Short answer: *Don't*. ("Friends don't let friends use excel for statistics.") Longer answer: