[R] Odp: "easiest" way to write an R dataframe to excel?

Petr PIKAL petr.pikal at precheza.cz
Tue Aug 24 08:52:25 CEST 2010


Hi

r-help-bounces at r-project.org napsal dne 23.08.2010 21:50:01:

> I am using R 2.11.1 in a Microsoft Windows 7 environment.
>  
> I tried using WriteXLS, but get the message " In system(cmd) : perl not 
found"
>  
> What is the "easiest" way to write an R dataframe to Excel?  (I am 
familiar with 
> WriteXLS, but I do not have PERL installed, and if not needed, do not 
wish to 
> install it.)
>  
> I am also familiar with write.table, but if possible, wish to create an 
excel 
> file form within R.

How big is your table

If it fit to clipboard you can

write.table(some.data.frame, "clipboard", sep="\t", row.names=FALSE)

and press CTRL-C in Excel

If not you can

write.table(some.data.frame, "mytable.xls", sep="\t", row.names=FALSE)

and the table is readable by Excel

Regards
Petr


>  
> I'm unsure if this is possible, or perhaps i should just go ahead and 
install 
> PERL...?
> 
> 
> 
>    [[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.



More information about the R-help mailing list