Hi Bryan (and Petr),
If you want to write tsv-style data from R to clipboard on a Mac (e.g.
for pasting into Numbers), you should do:
> x1 <- matrix(1:6, nrow =2)
> clip <- pipe("pbcopy", "w")
> write.table(x1, file=clip, sep = "\t", row.names = FALSE, fileEncoding =
> "UTF-8" )
> close(clip)
>
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
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
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
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
Hi
For rectangular data
write.table(tab, "clipboard", sep = "\t", row.names = F)
followed by Ctrl-V in Excel
or
write.table(tab, "somefile.xls", sep = "\t", row.names = F)
For free format output like summary(somefit) I prefer to copy it to Word and
use font like Courier New with monospaced le
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
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
8 matches
Mail list logo
