[R] Excel-Export

[Henrique Dallazuanna]

Use the RDCOMClient package from omegahat.org.

On Mon, Nov 23, 2009 at 11:02 AM, koj <jens.koch at 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 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.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O