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...@gmail.com > On Dec 28, 2016, at 6:33 PM, Jim Lemon <drjimle...@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...@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...@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. ______________________________________________ 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.
