[R] Excel Export in a beauty way

Gabor Grothendieck ggrothendieck at gmail.com
Wed Jun 3 16:06:00 CEST 2009


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.koch at 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 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.
>




More information about the R-help mailing list