Export R output in Excel
Hi Jim, Your assumption is correct. When running the analyses in R and want to export the output that appears in the console window to Excel(.csv) file. I believe it is easier to do if the export it done to an Excel (.CSV) file. So is there a way to export the analyses in the console window to a .CSV file with the good formatting ? I am looking to export the whole output if possible. I found this code, but it doesn?t cover the whole output of the console. write.csv(coef(summary(test)), file=?test.csv?) My whole output consists of descriptives and regressions. Best, Bryan Mac bryanmac.24 at gmail.com
On Dec 28, 2016, at 6:33 PM, Jim Lemon <drjimlemon at gmail.com> wrote: Hi Bryan, When I have to do something like this, I usually go through HTML output and import it into MS Word. I am not suggesting that this is the best thing to do, but it might get you out of trouble. I'm not sure whether importing HTML into Excel will work as well. I assume that you are running analyses in R and want to export the output that appears in the console window. If so, try producing HTML output with the prettyR or R2HTML packages and importing it. There are other ways to do this, but the learning curve is steep and you might not want to climb it right now. Jim On Thu, Dec 29, 2016 at 8:45 AM, Bryan Mac <bryanmac.24 at gmail.com> 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. Thanks. Bryan Mac bryanmac.24 at gmail.com
______________________________________________ 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.