[R] Export R dataframes to excel

Iain Gallagher iaingallagher at btopenworld.com
Tue Mar 1 22:11:22 CET 2011


This appeared today on the r-bloggers site and might be useful for you.

http://www.r-bloggers.com/release-of-xlconnect-0-1-3/

cheers

i

--- On Tue, 1/3/11, Steve Taylor <steve.taylor at aut.ac.nz> wrote:

> From: Steve Taylor <steve.taylor at aut.ac.nz>
> Subject: Re: [R] Export R dataframes to excel
> To: r-help at r-project.org, "maxsilva" <mmsilva3 at uc.cl>
> Date: Tuesday, 1 March, 2011, 20:15
> You can copy it with the following
> function and then paste into Excel...
>  
> copy = function (df, buffer.kb=256) {
>   write.table(df,
> file=paste("clipboard-",buffer.kb,sep=""),
>       sep="\t", na='', quote=FALSE,
> row.names=FALSE)
> }
> 
> 
> >>> 
> 
> From: maxsilva <mmsilva3 at uc.cl>
> To:<r-help at r-project.org>
> Date: 2/Mar/2011 8:50a
> Subject: [R] Export R dataframes to excel
> 
> I'm trying to do this in several ways but havent had any
> result. Im asked to
> install python, or perl.... etc. Can anybody suggest a
> direct, easy and
> understandable way?  Every help would be appreciated.
> 
> 
> Thx.
> 
> -- 
> View this message in context: http://r.789695.n4.nabble.com/Export-R-dataframes-to-excel-tp3330399p3330399.html
> 
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> 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 ( http://www.r/
> )-project.org/posting-guide.html
> and provide commented, minimal, self-contained,
> reproducible code.
> 
>     [[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