Re: [R] how to export ".xls" file with colorful cells?

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Thu, 24 Jul 2008 09:51:06 -0400

You didn't mention your OS but if its Windows then see:

http://tolstoy.newcastle.edu.au/R/help/05/07/8950.html

and try adding this line to that -- actually it gives me an error message (from Excel?) using Excel 2007 on Vista, RDCOMClient 0.92-0 and "R version 2.7.1 RC (2008-06-16 r45949)" but it seems to work in any case:

        x12[["Interior"]][["ColorIndex"]] <- 3

You will want to look at a VBA book and translate what you find to RDCOMClient notation in the manner of this example.

The rcom package can also be used in much the same way.

On Wed, Jul 23, 2008 at 9:29 PM, XinMeng <xmeng_at_capitalbio.com> wrote:
> Hi all:
> I wanna know how to expoort ".xls" file. And in the exported ".xls" file, how to set different cells with different color?
>
> Thanks a lot!
> My best.
>
>
>
> ------------------------------
> *******************************************
> Xin Meng
> Capitalbio Corporation
> National Engineering Research Center
> for Beijing Biochip Technology
> BioPharma-informatics & Software Dept.
> Research Engineer
> Tel: +86-10-80715888/80726868-6439
> Fax: +86-10-010-80726898
> Emailú║xmeng_at_capitalbio.com
> Address:18 Life Science Parkway,
> Changping District, Beijing 102206, China
>
>
> ______________________________________________
> 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.
>
>



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. Received on Thu 24 Jul 2008 - 13:54:55 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 24 Jul 2008 - 14:32:13 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive