[R] Odp: export tables to Excel files

[Petr PIKAL]

Hi

I use this simple statement to produce output readable directly to excel


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

If you put a name of a file instead of "clipboard" then you can use output 
to file and you can use append =TRUE

See ?write.table for further options. It is not so sophisticated as other 
possibilities but I got used to it and it works.

Regards
Petr

r-help-bounces at r-project.org napsal dne 23.02.2010 10:35:11:

> Dear R users,
> 
> I've just posted a similar question about Illustrator.
> This time I would like to export the results of my statistic tables and 
> my dataframes into Excel files.
> 
> Up to now I've used write.csv(), but I have to resave every file in .xls 

> in Excel.
> I would like to know if there is a function or package to export 
> directly into *.xls.
> 
> I have found xlsReadWrite which would be perfect for me, if only I could 

> append data to an existing file (I need to do it) and it doesn't work 
> with R2.10 (of course the version I use...).
> Of course, since I would like to export .xls files, I would have to be 
> able to read them too, which means that the package WriteXLS wouldn't be 

> enough. And in any case, appending data is not possible.
> The package xlsx is not what I need since I still use Excel 2003.
> 
> Are there other packages that would correspond to my needs? There might 
> also be a better, completely different, approach. I'm open to all 
> suggestions of course!
> 
> Thanks in advance for your help
> Ivan
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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.