R help - Apr 2005 - writing to an Excel file

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

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