Dear R Professionals, I am currently an intern at the University of Rhode Island and I need to know how to export data from R into an Excel file. As it is my understanding, xlsReadWrite is not available for mac. Is there another package available for mac users to be able to perform this function. Sincerely, Maureen J Hayden University of Rhode Island Class of 2015 Marine Biology Major [[alternative HTML version deleted]]
write.table() can easily export delimited text files that can be opened in the spreadsheet of your choice. If you need to export Excel specifically, rather than something Excel can open, you'll need a different answerer. Sarah On Thu, Jun 21, 2012 at 2:37 PM, Maureen Hayden <motrombone at my.uri.edu> wrote:> Dear R Professionals, > > I am currently an intern at the University of Rhode Island and I need to > know how to export data from R into an Excel file. As it is my > understanding, xlsReadWrite is not available for mac. Is there another > package available for mac users to be able to perform this function. > > Sincerely, > > Maureen J Hayden > University of Rhode Island > Class of 2015 > Marine Biology Major-- Sarah Goslee http://www.functionaldiversity.org
Check out the XLConnect package since it will allow you to write EXCEL workbooks directly. On Thu, Jun 21, 2012 at 2:37 PM, Maureen Hayden <motrombone at my.uri.edu> wrote:> Dear R Professionals, > > I am currently an intern at the University of Rhode Island and I need to > know how to export data from R into an Excel file. As it is my > understanding, xlsReadWrite is not available for mac. Is there another > package available for mac users to be able to perform this function. > > Sincerely, > > Maureen J Hayden > University of Rhode Island > Class of 2015 > Marine Biology Major > > ? ? ? ?[[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.-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.
You can try the following line. write.csv(x,file="x.csv") Eric Maureen Hayden wrote> > Dear R Professionals, > > I am currently an intern at the University of Rhode Island and I need to > know how to export data from R into an Excel file. As it is my > understanding, xlsReadWrite is not available for mac. Is there another > package available for mac users to be able to perform this function. > > Sincerely, > > Maureen J Hayden > University of Rhode Island > Class of 2015 > Marine Biology Major > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@ 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. >-- View this message in context: http://r.789695.n4.nabble.com/Exporting-data-from-R-into-an-Excel-File-on-Mac-tp4634141p4634146.html Sent from the R help mailing list archive at Nabble.com.