If had done a little searching before posting, you surely would have found
this link
https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html
which describes how to create .xls files that are customized any way that
you desire.

Kevin Wright


On Mon, Nov 23, 2009 at 7:02 AM, koj <jens.koch@gmx.li> wrote:

>
> Dear all,
>
> i use the following package/syntax to export data to excel:
>
> library(xlsReadWrite)
> write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames =
> FALSE )
>
> Everything is fine, but the format of the export is not the best. For
> example, I every time have to adjust the column width. Furthermore there is
> no possibility to highlight some cell or make them colourful.
>
> I create a lot of such outputs and I want to have the sheets in a nicer
> format to make them better readable, especially for the people, who works
> with my files.
>
> Have you any suggestions to reach this target? Ideally I can do this within
> R and not in a second step via a VBA-Makro or something like this. Is there
> a possibility in R, e. g. with a package?
>
> I have the same problem with the package xtable for export to Latex.
>
> I am very happy about the packages, but it would be perfect, if I can
> adjust
> some things in this direction. Probably there are somes ways for a
> solution.
> I am very glad about references.
>
> Thank you very much in advance,
>
> Jens.
>
>
>
>
> --
> View this message in context:
> http://old.nabble.com/Excel-Export-tp26477654p26477654.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.
>



-- 
Kevin Wright

	[[alternative HTML version deleted]]


