If you are willing to do the work RDCOMClient or rcom packages give you complete control. See example here: https://stat.ethz.ch/pipermail/r-help/2005-July/075877.html This assumes your platform is Windows and that you have R and Excel on the same machine so that R can control Excel.
On Wed, Jun 3, 2009 at 8:29 AM, koj <jens.k...@gmx.li> wrote: > > Hallo all, > > I`ve read a lot of things in this forum about an Excel export via R. It is > no problem to export my data frames via write.table or write.xls (xls or > csv), but some things are not very convenient for me: I always have to > adjust the column with to see all the numbers or the text and there is no > frame between the cells. And I missing the possibility to make some headers > bold or coloured. I`ve see the output from a Perl-Export and this is a very > nice thing, so my question: Is there really no possibility to produce a xls > or a xlsx - File with this nice features. > > Thank you very much in advance, > > Jens. > -- > View this message in context: > http://www.nabble.com/Excel-Export-in-a-beauty-way-tp23850532p23850532.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-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.
