Re: [R] Export R output in Excel

2016-12-29 Thread William Michels via R-help
Courier New with monospaced letters > > Cheers > Petr > > >> -Original Message- >> From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Bryan Mac >> Sent: Wednesday, December 28, 2016 10:45 PM >> To: R-help@r-project.org >> Subject

Re: [R] Export R output in Excel

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

Re: [R] Export R output in Excel

2016-12-29 Thread Spencer Graves
The "writeFindFn2xls" function in the sos package include 3 different ways to write an Excel workbook, depending on which packages, etc., you have installed. I wrote that, because I could not find one contributed package that as easy to install on every operating system. This writes an

Re: [R] Export R output in Excel

2016-12-29 Thread Jim Lemon
Hi Bryan, What functions like "htmlize" (prettyR) do is format the basic R output into HTML tables with the option of interspersed graphics. While I usually stop at the HTML stage, the output files can be imported into Word for those who cannot work out how to open them with an HTML browser. I just

Re: [R] Export R output in Excel

2016-12-29 Thread John Dougherty
On Wed, 28 Dec 2016 13:45:25 -0800 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. > > Thanks. > > Bryan Mac > bryanmac...@gmail.com > Your purpose is not cl

Re: [R] Export R output in Excel

2016-12-28 Thread PIKAL Petr
e font like Courier New with monospaced letters Cheers Petr > -Original Message- > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Bryan Mac > Sent: Wednesday, December 28, 2016 10:45 PM > To: R-help@r-project.org > Subject: [R] Export R output in Excel &

Re: [R] Export R output in Excel

2016-12-28 Thread Omar André Gonzáles Díaz
use "write.csv("you-df", "name-of-file.csv", row.names = FALSE). And Google please, as others have suggested. 2016-12-28 21:33 GMT-05:00 Jim Lemon : > 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 i

Re: [R] Export R output in Excel

2016-12-28 Thread Jim Lemon
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 a

[R] Export R output in Excel

2016-12-28 Thread Bryan Mac
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 UNSUBSCRI