If you are working on Windows and Excel installed on the same machine
as R,
the rcom library by Thomas Baier gives you full programmability for
Excel From R.
You can control all the effect you want.
You also could use the RExcel addin for Excel
which allows to transfer date from R into Excel with Excel menus.
Then you can change everything you want in Excel manually or with VBA
macros.
On Jun 3, 2009, at 2:29 PM, koj 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.
--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
______________________________________________
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.
