[R] writing to an Excel file

Petr Pikal petr.pikal at precheza.cz
Mon Apr 11 06:54:28 CEST 2005


Hi Laura

Pretty common question. You could find an answer going through 
archives.
To copy to Excel through clipboard:

write.excel<-function(tab, ...) write.table( tab, "clipboard", 
sep="\t", row.names=F)

write.excel(your.data.frame)

open Excel and press ctrl-C

Cheers
Petr


On 10 Apr 2005 at 19:56, Laura Holt wrote:

> Hi R!
> 
> Is there a special function that writes data to an Excel file, please?
> 
> I found read.spss and so on in the foreign library, but nothing to
> write.
> 
> Of course, writing to a regular data file and importing into Excel
> works fine, but I thought that there might be another way.
> 
> Thanks in advance.
> 
> Sincerely,
> Laura Holt
> mailto: lauraholt_983 at hotmail.com
> R Version 2.0.1 Windows
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html

Petr Pikal
petr.pikal at precheza.cz




More information about the R-help mailing list