Check the WriteXLS package, I think it does that and also saves each R object on a different excel sheet. Felipe D. Carrillo Supervisory Fishery Biologist Department of the Interior US Fish & Wildlife Service California, USA
----- Original Message ---- > From: eugen pircalabelu <eugen_pircalab...@yahoo.com> > To: R-help <r-h...@stat.math.ethz.ch> > Sent: Tue, July 13, 2010 1:21:33 PM > Subject: [R] export tables to excel files on multiple sheets with titles for >each table > > Hello R-users, > Checking the archives, I recently came across this topic: > "export tables to Excel files" >(http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), >, > and the following interesting references have been proposed: > http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows > http://www.r-bloggers.com/export-data-frames-to-multi-worksheet-excel-file-2/ > > but my problem is somehow a small extension to what has been discussed, and > although i have a solution, i seek something more elegant. I want to export > multiple dataframes (on multiple sheets), but i also want each of them to > have > its own title that is to be written also in Excel. The packages/functions > that >i > > have checked, cannot accommodate a title that is to be written on the sheet, > along with the actual dataframe of interest. > > I can do something similar to what i need, but without writing the dataframes >on > > multiple sheets. > > #head(USArrests) and head(iris) written with accompanying title one under > each > other > > write.excel<-function (tab, ...){ > zz <- file("example.dat", "a+b") > cat("\"TITLE extra line",file = zz, sep = "\n") > write.table(tab, file=zz, row.names=F,sep="\t") > close(zz)} > write.excel(head(USArrests)) > write.excel(head(iris)) > > Any suggestion on how to export the same information on two separate sheets, >and > > keeping also a title for each of them, is highly appreciated, as i have been > searching for some time for a good solution. > > Thank you very much and have a great day ahead! > > > > > > > Eugen Pircalabelu > (0032)471 842 140 > (0040)727 839 293 > > ______________________________________________ > R-help@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. > ______________________________________________ R-help@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.