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.
write.table() using the sep="," and file extension as .csv works great to pull directly into excel. ?write.table Without more detail as to the problem, it is difficult to give a more specific answer. Adrian -----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of maxsilva Sent: Tuesday, March 01, 2011 2:11 PM To: r-help at r-project.org 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-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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@uc.cl> To:<r-help@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@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]]
Or ?write.csv which excel will import On 1-Mar-11, at 12:17 PM, Berend Hasselman wrote:> > maxsilva wrote: >> >> Thx, but im looking for a more direct solution... my problem is very >> simple, I have a dataframe and I want to create a standard excel >> spreadsheet. My dataframe could be something like this >> > > More or less the same question was answered several hours ago. > See http://rwiki.sciviews.org/doku.php?id=tips:data- > io:ms_windows&s=excel > as Gabor Grothendieck suggested. > > /Berend > > -- > View this message in context: http://r.789695.n4.nabble.com/Export- > R-dataframes-to-excel-tp3330399p3330518.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-project.org/posting- > guide.html > and provide commented, minimal, self-contained, reproducible code.Why does the universe go to all the bother of existing? -- Stephen Hawking #define QUESTION ((bb) || !(bb)) -- William Shakespeare Don McKenzie, Research Ecologist Pacific WIldland Fire Sciences Lab US Forest Service Affiliate Professor School of Forest Resources, College of the Environment CSES Climate Impacts Group University of Washington desk: 206-732-7824 cell: 206-321-5966 dmck at uw.edu donaldmckenzie at fs.fed.us