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 <[EMAIL PROTECTED]> 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 PROTECTED]
> Address:18 Life Science Parkway,
> Changping District, Beijing 102206, China
>
>
> ______________________________________________
> 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.
>
>
______________________________________________
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.
