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.
