If I am correctly understanding what Eugen is trying to do, WriteXLS() won't get him there. WriteXLS() will enable you to label/name the worksheets (tabs) but not allow you to precede the actual data frame rows and columns on the sheet with a title or label.
I suspect that you may have to look at the RCom package tools for this. This provides greater flexibility in writing to the worksheets and cells. See http://rcom.univie.ac.at/ for more information. HTH, Marc Schwartz On Jul 13, 2010, at 4:09 PM, Felipe Carrillo wrote: > 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! ______________________________________________ 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.
